create table sm_t_night_construction (
|
NC_Id int(11) PRIMARY KEY,
|
NC_Num VARCHAR(50) DEFAULT NULL,
|
NC_Item_Name VARCHAR(50) DEFAULT NULL,
|
NC_Item_Unit VARCHAR(50) DEFAULT NULL,
|
NC_Province_Code VARCHAR(50) DEFAULT NULL,
|
NC_Province_Name VARCHAR(50) DEFAULT NULL,
|
NC_City_Code VARCHAR(50) DEFAULT NULL,
|
NC_City_Name VARCHAR(50) DEFAULT NULL,
|
NC_District_Code VARCHAR(50) DEFAULT NULL,
|
NC_District_Name VARCHAR(50) DEFAULT NULL,
|
NC_Construction_Unit VARCHAR(50) DEFAULT NULL,
|
NC_Person VARCHAR(50) DEFAULT NULL,
|
NC_Apply_Content VARCHAR(50) DEFAULT NULL,
|
NC_Start_Date datetime DEFAULT NULL,
|
NC_End_Date datetime DEFAULT NULL,
|
NC_File_Name VARCHAR(50) DEFAULT NULL,
|
NC_Create_Time datetime DEFAULT NULL,
|
NC_Url VARCHAR(50) DEFAULT NULL,
|
NC_User_Id VARCHAR(50) DEFAULT NULL,
|
NC_Scene_Id VARCHAR(50) DEFAULT NULL,
|
NC_Read Boolean DEFAULT NULL )ENGINE =INNODB DEFAULT CHARSET= utf8;
|
create table sm_t_scene_construction_site (
|
S_GUID VARCHAR(16) NOT NULL PRIMARY KEY,
|
CS_Project_Type VARCHAR(50) DEFAULT NULL,
|
CS_Status VARCHAR(50) DEFAULT NULL,
|
CS_Start_Time VARCHAR(50) DEFAULT NULL,
|
CS_End_Time VARCHAR(50) DEFAULT NULL,
|
CS_Left_Time VARCHAR(50) DEFAULT NULL,
|
CS_Floor_Space VARCHAR(50) DEFAULT NULL,
|
CS_Construction_Area VARCHAR(50) DEFAULT NULL,
|
CS_Construction_Area_Per_Month VARCHAR(50) DEFAULT NULL,
|
CS_Employer_Unit VARCHAR(50) DEFAULT NULL,
|
CS_Employer_Contacts VARCHAR(50) DEFAULT NULL,
|
CS_Employer_Contacts_Tel VARCHAR(50) DEFAULT NULL,
|
CS_Construction_Unit VARCHAR(50) DEFAULT NULL,
|
CS_Construction_Contacts VARCHAR(50) DEFAULT NULL,
|
CS_Construction_Contacts_Tel VARCHAR(50) DEFAULT NULL,
|
CS_Security_Officer VARCHAR(50) DEFAULT NULL,
|
CS_Security_Officer_Tel VARCHAR(50) DEFAULT NULL,
|
SI_Extension1 VARCHAR(50) DEFAULT NULL,
|
SI_Extension2 VARCHAR(50) DEFAULT NULL,
|
SI_Extension3 VARCHAR(50) DEFAULT NULL,
|
SI_Remark VARCHAR(50) DEFAULT NULL )ENGINE =INNODB DEFAULT CHARSET= utf8;
|
create table sm_t_scene_device (
|
S_GUID VARCHAR(16) NOT NULL PRIMARY KEY,
|
SD_Num int(11) DEFAULT NULL,
|
SD_Location VARCHAR(50) DEFAULT NULL,
|
SD_Ops_Unit VARCHAR(50) DEFAULT NULL,
|
SD_Status VARCHAR(50) DEFAULT NULL,
|
SD_Location_Reasonable VARCHAR(50) DEFAULT NULL,
|
SD_Port_Height VARCHAR(50) DEFAULT NULL,
|
SD_Port_Status VARCHAR(50) DEFAULT NULL,
|
SD_Data_Expection VARCHAR(50) DEFAULT NULL,
|
SI_Extension1 VARCHAR(50) DEFAULT NULL,
|
SI_Extension2 VARCHAR(50) DEFAULT NULL,
|
SI_Extension3 VARCHAR(50) DEFAULT NULL,
|
SI_Remark VARCHAR(50) DEFAULT NULL )ENGINE =INNODB DEFAULT CHARSET= utf8;
|
create table sm_t_scene_mixing_plant (
|
S_GUID VARCHAR(16) NOT NULL PRIMARY KEY,
|
MP_Status VARCHAR(50) DEFAULT NULL,
|
MP_Floor_Space VARCHAR(50) DEFAULT NULL,
|
MP_Planning_Area VARCHAR(50) DEFAULT NULL,
|
MP_Employer_Unit VARCHAR(50) DEFAULT NULL,
|
MP_Employer_Contacts VARCHAR(50) DEFAULT NULL,
|
MP_Employer_Contacts_Tel VARCHAR(50) DEFAULT NULL,
|
MP_Green_Plant Boolean DEFAULT NULL,
|
MP_Civilly_Plant Boolean DEFAULT NULL,
|
SI_Extension1 VARCHAR(50) DEFAULT NULL,
|
SI_Extension2 VARCHAR(50) DEFAULT NULL,
|
SI_Extension3 VARCHAR(50) DEFAULT NULL,
|
SI_Remark VARCHAR(50) DEFAULT NULL )ENGINE =INNODB DEFAULT CHARSET= utf8;
|
create table sm_t_scene_storage_yard (
|
S_GUID VARCHAR(16) NOT NULL PRIMARY KEY,
|
SY_Project_Type VARCHAR(50) DEFAULT NULL,
|
SY_Status VARCHAR(50) DEFAULT NULL,
|
SY_Business_Certificate VARCHAR(50) DEFAULT NULL,
|
SY_Floor_Space VARCHAR(50) DEFAULT NULL,
|
SY_Planning_Area VARCHAR(50) DEFAULT NULL,
|
SY_Employer_Unit VARCHAR(50) DEFAULT NULL,
|
SY_Employer_Contacts VARCHAR(50) DEFAULT NULL,
|
SY_Employer_Contacts_Tel VARCHAR(50) DEFAULT NULL,
|
SY_Rent_Unit VARCHAR(50) DEFAULT NULL,
|
SY_Rent_Contacts VARCHAR(50) DEFAULT NULL,
|
SY_Rent_Contacts_Tel VARCHAR(50) DEFAULT NULL,
|
SI_Extension1 VARCHAR(50) DEFAULT NULL,
|
SI_Extension2 VARCHAR(50) DEFAULT NULL,
|
SI_Extension3 VARCHAR(50) DEFAULT NULL,
|
SI_Remark VARCHAR(50) DEFAULT NULL )ENGINE =INNODB DEFAULT CHARSET= utf8;
|
create table sm_t_scene_wharf (
|
S_GUID VARCHAR(16) NOT NULL PRIMARY KEY,
|
W_Project_Type VARCHAR(50) DEFAULT NULL,
|
W_Status VARCHAR(50) DEFAULT NULL,
|
W_Business_Certificate VARCHAR(50) DEFAULT NULL,
|
W_Floor_Space VARCHAR(50) DEFAULT NULL,
|
W_Planning_Area VARCHAR(50) DEFAULT NULL,
|
W_Employer_Unit VARCHAR(50) DEFAULT NULL,
|
W_Employer_Contacts VARCHAR(50) DEFAULT NULL,
|
W_Employer_Contacts_Tel VARCHAR(50) DEFAULT NULL,
|
W_Rent_Unit VARCHAR(50) DEFAULT NULL,
|
W_Rent_Contacts VARCHAR(50) DEFAULT NULL,
|
W_Rent_Contacts_Tel VARCHAR(50) DEFAULT NULL,
|
SI_Extension1 VARCHAR(50) DEFAULT NULL,
|
SI_Extension2 VARCHAR(50) DEFAULT NULL,
|
SI_Extension3 VARCHAR(50) DEFAULT NULL,
|
SI_Remark VARCHAR(50) DEFAULT NULL )ENGINE =INNODB DEFAULT CHARSET= utf8;
|
