An introduction of Schema & Micro Service driven dynamic web application using ReactJS and Python

Asset Management Solution Part 1
In this video, I have covered the basic foundation of Asset Management solution and it's need in the current world. I also have explained the basic infrastructure and software required to build the solution using Facebook ReactJS and Python / Django. If you are looking to build your own web application then this is the right place to start.

This post detailed writeup and sourcecode: TBD

Important Information:
VM Central: https://www.vmcentral.com.au/
How to Install SQL Server: https://www.sqlshack.com/manage-sql-databases-in-centos-install-sql-server-on-centos/
SSH Tunnelling: https://phoenixnap.com/kb/ssh-with-key
https://linuxize.com/post/how-to-setup-ssh-tunneling/
DJango: https://www.djangoproject.com/
Apache: https://www.apache.org/
MUI: https://mui.com/
ReactJS: https://reactjs.org/

Database Script:
CREATE TABLE page (
slno int NOT NULL IDENTITY,
id varchar (36) NOT NULL,

name nvarchar(max) NOT NULL,
description nvarchar(max) NOT NULL,
properties nvarchar(max) NOT NULL,

app_id varchar (36) NOT NULL,
sid varchar (36) NOT NULL,
rid varchar (36) NOT NULL,
category varchar(32) NOT NULL,
subcategory varchar(32) NOT NULL,
modifiedBy varchar (36) NOT NULL,
modifiedOn datetime NOT NULL,
status int DEFAULT 0,
version int DEFAULT 0,
transactionId varchar (36) NOT NULL
);

CREATE TABLE service (
slno int NOT NULL IDENTITY,
id varchar (36) NOT NULL,

name nvarchar(max) NOT NULL,
description nvarchar(max) NOT NULL,
url varchar(512) NOT NULL,
properties nvarchar(max) NOT NULL,

app_id varchar (36) NOT NULL,
sid varchar (36) NOT NULL,
rid varchar (36) NOT NULL,
category varchar(32) NOT NULL,
subcategory varchar(32) NOT NULL,
modifiedBy varchar (36) NOT NULL,
modifiedOn datetime NOT NULL,
status int DEFAULT 0,
version int DEFAULT 0,
transactionId varchar (36) NOT NULL
);

Music source: https://mixkit.co/free-sound-effects
Other video sources: https://www.pexels.com/

I am not an expert, I am learning while I am making this video. If I am making mistakes please help and please comment your opinion
Thank you for watching

To support me please visit: https://www.patreon.com/themakingofothers