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;