{
":database":{
":crud-action":"create",
"name":"another_unify_schools",
":table-group":[
{
":crud-action":"create",
"name":"students",
"columns":[
{
"name":"id",
"data-type":"int",
"primary-key":true
},
{
"name":"first_name",
"data-type":"varchar(20)",
"default":"'samuel'"
},
{
"name":"last_name",
"data-type":"varchar(20)"
},
{
"name":"class",
"data-type":"varchar(10)"
}
]
},
{
":crud-action":"create",
"name":"faculty",
"columns":[
{
"name":"fac_id",
"data-type":"int",
"auto_increment":true,
"primary-key":true
},
{
"name":"first_name",
"data-type":"varchar(20)"
},
{
"name":"last_name",
"data-type":"varchar(20)"
}
]
},
{
":crud-action":"create",
"name":"subjects",
"columns":[
{
"name":"subject_id",
"data-type":"int",
"auto_increment":true,
"primary-key":true
},
{
"name":"subject_name",
"data-type":"varchar(30)"
},
{
"name":"subject_faculty",
"data-type":"int",
"foreign-key":"(subject_faculty)",
"references":"faculty(fac_id)",
"on-update":"cascade",
"on-delete":"set null"
}
]
}
]
}
}
|
Download
