--Create Table AlexMonitor.Milestone (
--
--Milestone_ID NUMBER(8)             NOT NULL,
--Milestone_Name varchar2(20)      NOT NULL,
--Milestone_Desc  varchar2(400) ,
--Primary Key(Milestone_ID )              ) Tablespace  ttRealTime_StaticSpace;

/*Create table of Project for the user of AutoMonitor*/

--Create Table AlexMonitor.Project(
--
--Project_ID      NUMBER(8)            NOT NULL,
--Project_Name VARCHAR2(20)      NOT NULL,
--Project_Desc  VARCHAR2(400) ,  
--
--Primary Key(Project_ID)                   ) Tablespace ttRealTime_StaticSpace;

/* Create  Table  of TestStationSquence for AutoMonitor */

--Create Table AlexMonitor.TestStationSquence(
--
--TestStationSquence_ID NUMBER(8) NOT NULL,
--TestStationSquence_Num NUMBER(3) NOT NULL,
--TestStationSquence_DESC VARCHAR(400),
--
--Primary Key(TestStationSquence_ID) ) TableSpace ttRealTime_StaticSpace;

--Create Table AlexMonitor.TestStation(
--
--TestStation_ID               NUMBER(8) NOT NULL,
--TestStation_Name          VARCHAR2(20) NOT NULL,
--TestStationSquence_ID   NUMBER(8) NOT NULL,
--TestStation_Index           NUMBER(3) NOT NULL,
--TestStation_Desc            VARCHAR2(400),
--
--Primary Key(TestStation_ID) ,
--Foreign Key(TestStationSquence_ID)  references AlexMonitor.TestStationSquence(TestStationSquence_ID) on delete cascade ) Tablespace ttRealTime_StaticSpace;

--Create Table AlexMonitor.ProduceFlow(
--
--ProduceFlow_ID       NUMBER(8)           NOT NULL,
--Project_ID              NUMBER(8)           NOT NULL,
--Milestone_ID           NUMBER(8)           NOT NULL,
--TestStationSquence_ID NUMBER(8) NOT NULL,
--ProduceFlow_Desc   VARCHAR2(400)   ,
--
--Primary Key(ProduceFlow_ID),
--Foreign Key(Project_ID)     references AlexMonitor.project(Project_ID) on delete cascade,
--Foreign Key(TestStationSquence_ID) references AlexMonitor.TestStationSquence(TestStationSquence_ID)  on delete cascade,
--Foreign Key(Milestone_ID) references AlexMonitor.MILESTONE(Milestone_ID)  on delete cascade) Tablespace ttRealTime_StaticSpace;

/*Create Table  of ProduceLine  for user of AutoMonitor*/

--Create Table AlexMonitor.ProduceLine(
--
--PL_ID   VARCHAR2(40)  NOT NULL,
--ProduceFlow_ID  NUMBER(8)   NOT NULL,
--PL_Name VARCHAR2(20)  NOT NULL,
--PL_Addr  VARCHAR2(40)  NOT NULL,
--PL_Type  VARCHAR2(40)  NOT NULL,
--PL_CreateTime  timestamp(2) ,
--PL_ReleaseTime timestamp(2),
--PL_Expect_UPH   NUMBER(6,2)  NOT NULL,
--PL_Expect_Yield NUMBER(6,2)  NOT NULL,
--PL_Monitor_Name VARCHAR2(20) ,
--PL_Monitor_Tel   VARCHAR(40), 
--
--Primary Key(PL_ID) ,
--Foreign Key(ProduceFlow_ID) references AlexMonitor.ProduceFlow(ProduceFlow_ID) on delete cascade ) Tablespace ttRealTime_StaticSpace;

/*Create Table  of Server  for user of AutoMonitor*/

--Create Table AlexMonitor.Server(
--
--Server_ID VARCHAR2(40) NOT NULL,
--PL_ID   VARCHAR2(40)   NOT  NULL,
--Server_Name VARCHAR2(20),
--Server_IP      VARCHAR2(40) ,
--Server_Mac_Address VARCHAR2(40),
--
--Primary Key(Server_ID),
--Foreign Key(PL_ID) references AlexMonitor.ProduceLine(PL_ID)  on delete cascade) Tablespace ttRealTime_StaticSpace;

/*Create Table  of Robot_Type  for user of AutoMonitor*/

--CREATE TABLE AlexMonitor.Robot_Type(
--   RT_ID NUMBER(8) NOT NULL,
--   RT_Bulk NUMBER(8,4),
--   RT_Weight NUMBER(8,4),
--   RT_Controller_Name VARCHAR2(40),
--   RT_Controller_Type VARCHAR2(40),
--   RT_Axis_Count NUMBER(2),
--   RT_Acceleration NUMBER(8,4),
--   RT_Max_Speed NUMBER(8,4),
--   RT_Hand_Count NUMBER(2),
--   RT_Allow_Station VARCHAR2(40),
--   RT_Allow_Warp NUMBER(8,4),
--   RT_Allow_Weight NUMBER(8,4),
--PRIMARY KEY (RT_ID) )TABLESPACE ttRealTime_StaticSpace ; 

--/*Create Table  of RobotManagement  for user of AutoMonitor*/
--
--Create Table AlexMonitor.RobotManagement(
--
--Robot_ID VARCHAR(40) NOT NULL,
--RT_ID  NUMBER(8) NOT NULL,
--Server_ID VARCHAR(40) NOT NULL,
--Robot_Name VARCHAR2(20) NOT NULL,
--Robot_IP VARCHAR(40),
--Robot_Use_State VARCHAR(40),
--Robot_Port  NUMBER(6),
--Robot_Expect_Yield NUMBER(6,2),
--Robot_Expect_UPH  NUMBER(6,2),
--
--Primary Key(Robot_ID),
--Foreign Key(RT_ID) references AlexMonitor.Robot_Type(RT_ID) on delete cascade,
--Foreign Key(Server_ID) references AlexMonitor.Server(Server_ID) on delete cascade) Tablespace ttRealTime_StaticSpace;

--/*Create Table  of  Station  for user of AutoMonitor*/
--
--Create Table AlexMonitor.Station(
--
--Station_ID VARCHAR(40) NOT NULL,
--Robot_ID VARCHAR(40) NOT NULL,
--TestStation_ID NUMBER(8) NOT NULL,
---Station_Name VARCHAR2(20) NOT NULL,
--Station_IP  VARCHAR2(40),
--Station_Mac_Addr VARCHAR2(40),
--Staion_Type  VARCHAR2(40) NOT NULL,
--
--
--Primary Key(Station_ID) ,
--Foreign Key(Robot_ID) references AlexMonitor.RobotManagement(Robot_ID) on delete cascade,
--Foreign Key(TestStation_ID) references AlexMonitor.TestStation(TestStation_ID) on delete cascade) Tablespace ttRealTime_StaticSpace;

/*Create Table of Fixture for the user of  AutoMonitor*/

--CREATE TABLE AlexMonitor.Fixture(
--  Fix_ID VARCHAR2(40) NOT NULL,
--  Station_ID VARCHAR(40),
--  Fix_Name Varchar2(40) Not NULL,
-- --- Fix_For_Station VARCHAR2(40) NOT NULL,
--  Fix_Uart_Count NUMBER(4),
--  Fix_USB_Count NUMBER(4),
--  Fix_Bulk NUMBER(8,4),
--  Fix_Weight NUMBER(8,4),
--  Fix_Holder_Count NUMBER(4),
--  Fix_Firmware_Version VARCHAR2(40),
--  Fix_Produce_Date date,
--  Fix_Factory VARCHAR2(80),
--PRIMARY KEY(Fix_ID),
--Foreign key (Station_ID) references AlexMonitor.Station(Station_ID) on delete cascade) Tablespace ttRealTime_StaticSpace;