1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
| Create table AM_Host
(
HOST VARCHAR2(40)
, Data_Center varchar2(10) constraint cnstrnt_dc check (Data_Center in ('DC01','DC02','DC03','DC04','DC05','Amazon','NULL'))
, PRIMARY KEY (HOST)
)
Create table AM_Guest
(
Guest VARCHAR2(40)
, IP VARCHAR2(45)
, DNS VARCHAR2(250)
, Ram int(8)
, Threads int(8)
, IP_Backup VARCHAR2(45)
, Product varchar2(60)
, PRIMARY KEY (Guest)
)
Create Table AM_customer
(
HOST VARCHAR2(40)
, Guest VARCHAR2(40)
, CUSTOMER_NAME VARCHAR2(250)
, CUSTOMER_CODE VARCHAR2(80)
, SERVER_TYPE VARCHAR2(45)
, STATUS VARCHAR2(45)
, CONTACT_MAILS VARCHAR2(500)
, NOTE VARCHAR2(250)
, FOREIGN KEY (HOST) REFERENCES AM_Host(HOST)
, FOREIGN KEY (Guest) REFERENCES AM_Guest(Guest)
) |
Partager