PHP Classes
elePHPant
Icontem

File: tests/json/1.json

Recommend this page to a friend!
  Classes of Samuel Adeshina  >  Scripd  >  tests/json/1.json  >  Download  
File: tests/json/1.json
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: Scripd
Generate database creation SQL queries from JSON
Author: By
Last change: Merge branch 'master' of https://github.com/Samshal/Scripd
Date: 3 years ago
Size: 1,354 bytes
 

Contents

Class file image Download
{
	":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"
					}
				]
			}
		]
	}
}