Scribd
Upload
53 views21 pages

Er Script

The document contains SQL commands for creating various database tables including COUNTRY_INFO, SEASON_INFO, ORDER_UDF_VALUE, BUYER_INFO, and others. Each table is defined with specific columns, data types, and storage parameters within the USERS tablespace. The tables are designed to store information related to countries, seasons, orders, buyers, user roles, and company details among others.

Uploaded by

ziaur06
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
53 views21 pages

Er Script

The document contains SQL commands for creating various database tables including COUNTRY_INFO, SEASON_INFO, ORDER_UDF_VALUE, BUYER_INFO, and others. Each table is defined with specific columns, data types, and storage parameters within the USERS tablespace. The tables are designed to store information related to countries, seasons, orders, buyers, user roles, and company details among others.

Uploaded by

ziaur06
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 21

CREATE TABLE COUNTRY_INFO

(
ID NUMBER,
COUNTRY_CODE VARCHAR2(20 BYTE) NOT NULL,
COUNTRY_NAME VARCHAR2(100 BYTE) NOT NULL
)
TABLESPACE USERS
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
NOCOMPRESS
NOCACHE
NOPARALLEL
MONITORING
/

CREATE TABLE SEASON_INFO


(
ID NUMBER,
SEASON_NAME VARCHAR2(100 BYTE),
SEASON_DESCRIPTION VARCHAR2(200 BYTE)
)
TABLESPACE USERS
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
NOCOMPRESS
NOCACHE
NOPARALLEL
MONITORING
/

CREATE TABLE ORDER_UDF_VALUE


(
ID NUMBER,
OD_ID NUMBER,
UDF_ID NUMBER,
VALUE VARCHAR2(300 BYTE)
)
TABLESPACE USERS
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
NOCOMPRESS
NOCACHE
NOPARALLEL
MONITORING
/

CREATE TABLE BUYER_INFO


(
ID NUMBER,
BUYER_CODE VARCHAR2(10 BYTE) NOT NULL,
BUYER_NAME VARCHAR2(100 BYTE),
BUYER_COUNTRY_ID NUMBER,
BUYER_ADDRESS1 VARCHAR2(200 BYTE),
BUYER_ADDRESS2 VARCHAR2(200 BYTE),
BUYER_ADDRESS3 VARCHAR2(200 BYTE),
BUYER_PHONE VARCHAR2(20 BYTE),
BUYER_FAX VARCHAR2(20 BYTE),
BUYER_EMAIL VARCHAR2(50 BYTE),
BUYER_ALTERNATE_EMAIL VARCHAR2(50 BYTE),
BUYER_CONTACT_PERSON VARCHAR2(100 BYTE),
BUYER_WEB_ADDRESS VARCHAR2(100 BYTE),
RECORD_STATUS NUMBER(1),
CREATE_USER VARCHAR2(100 BYTE),
CREATION_DATE DATE,
CREATE_TERMINAL VARCHAR2(100 BYTE),
MODIFY_USER VARCHAR2(100 BYTE),
MODIFICATION_DATE DATE,
MODIFY_TERMINAL VARCHAR2(100 BYTE)
)
TABLESPACE USERS
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
NOCOMPRESS
NOCACHE
NOPARALLEL
MONITORING
/

CREATE TABLE ORDER_MASTER


(
ID NUMBER,
OM_CODE VARCHAR2(20 BYTE),
OM_TITLE VARCHAR2(100 BYTE),
OM_DESCRIPTION VARCHAR2(255 BYTE),
OM_BUYER_ID NUMBER,
OM_DATE DATE,
OM_LAST_SHIPMENT_DATE DATE,
OM_TOTAL_QUANTITY NUMBER,
OM_TOTAL_PRICE NUMBER,
OM_ADDITIONAL_QUANTITY NUMBER,
OM_MASTER_LC VARCHAR2(100 BYTE),
OM_GAUGE VARCHAR2(20 BYTE),
OM_REMARKS VARCHAR2(100 BYTE),
OM_SEASON_ID NUMBER,
OM_STATUS CHAR(1 BYTE),
RECORD_STATUS NUMBER(1),
CREATE_USER VARCHAR2(100 BYTE),
CREATION_DATE DATE,
CREATE_TERMINAL VARCHAR2(100 BYTE),
MODIFY_USER VARCHAR2(100 BYTE),
MODIFICATION_DATE DATE,
MODIFY_TERMINAL VARCHAR2(100 BYTE),
CURRENCY_CODE VARCHAR2(3 BYTE),
OM_YARN_COUNT VARCHAR2(50 BYTE),
OM_YARN_DESCRIPTION VARCHAR2(300 BYTE),
OM_AVG_WEIGHT NUMBER
)
TABLESPACE USERS
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
NOCOMPRESS
NOCACHE
NOPARALLEL
MONITORING
/

CREATE TABLE SIZE_INFO


(
SIZE_CODE NUMBER(5),
SIZE_NAME VARCHAR2(30 BYTE),
SIZE_SNAME VARCHAR2(15 BYTE),
USER_ID VARCHAR2(10 BYTE),
ACTION_DT DATE DEFAULT sysdate NOT
NULL
)
TABLESPACE USERS
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
NOCOMPRESS
NOCACHE
NOPARALLEL
MONITORING
/

CREATE TABLE COLOR_INFO


(
COLOR_CODE NUMBER(5),
COLOR_NAME VARCHAR2(100 BYTE) NOT NULL,
COLOR_SNAME VARCHAR2(15 BYTE),
USER_ID VARCHAR2(10 BYTE),
ACTION_DT DATE DEFAULT sysdate NOT
NULL
)
TABLESPACE USERS
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
NOCOMPRESS
NOCACHE
NOPARALLEL
MONITORING
/

CREATE TABLE CURRENCY


(
CURRENCY_CODE VARCHAR2(3 BYTE),
CURRENCY_NAME VARCHAR2(200 BYTE) NOT NULL
)
TABLESPACE USERS
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
NOCOMPRESS
NOCACHE
NOPARALLEL
MONITORING
/

CREATE TABLE ORDER_DETAILS


(
ID NUMBER,
OM_ID NUMBER,
OD_SIZE_CODE NUMBER(5),
OD_COLOR_CODE NUMBER(5),
OD_QUANTITY NUMBER(10),
OD_UNIT_PRICE NUMBER(10,4),
RECORD_STATUS NUMBER(1),
CREATE_USER VARCHAR2(100 BYTE),
CREATION_DATE DATE,
CREATE_TERMINAL VARCHAR2(100 BYTE),
MODIFY_USER VARCHAR2(100 BYTE),
MODIFICATION_DATE DATE,
MODIFY_TERMINAL VARCHAR2(100 BYTE)
)
TABLESPACE USERS
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
NOCOMPRESS
NOCACHE
NOPARALLEL
MONITORING
/

CREATE TABLE EVENT


(
EVENT_CODE VARCHAR2(5 BYTE),
EVENT_NAME VARCHAR2(50 BYTE) NOT NULL,
ACTION_URL VARCHAR2(100 BYTE) NOT NULL
)
TABLESPACE USERS
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
NOCOMPRESS
NOCACHE
NOPARALLEL
MONITORING
/

CREATE TABLE UDF


(
ID NUMBER,
UDF_NAME VARCHAR2(100 BYTE),
UDF_EVENT_CODE VARCHAR2(5 BYTE)
)
TABLESPACE USERS
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
NOCOMPRESS
NOCACHE
NOPARALLEL
MONITORING
/

CREATE TABLE RIGHTS


(
ID NUMBER,
RIGHT_NAME VARCHAR2(100 BYTE)
)
TABLESPACE USERS
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
NOCOMPRESS
NOCACHE
NOPARALLEL
MONITORING
/

CREATE TABLE ROLE


(
ID NUMBER,
ROLE_NAME VARCHAR2(50 BYTE)
)
TABLESPACE USERS
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
NOCOMPRESS
NOCACHE
NOPARALLEL
MONITORING
/

CREATE TABLE ROLE_RIGHTS


(
ROLE_ID NUMBER,
RIGHTS_ID NUMBER
)
TABLESPACE USERS
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
NOCOMPRESS
NOCACHE
NOPARALLEL
MONITORING
/

CREATE TABLE USER_ROLE


(
USERID NUMBER,
ROLEID NUMBER
)
TABLESPACE USERS
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
NOCOMPRESS
NOCACHE
NOPARALLEL
MONITORING
/

CREATE TABLE USER_INFO


(
USERID NUMBER,
USERNAME VARCHAR2(50 BYTE),
PASSWORD VARCHAR2(20 BYTE),
USER_FULLNAME VARCHAR2(100 BYTE),
USER_SURNAME VARCHAR2(50 BYTE),
USER_EMPLOYEE_ID VARCHAR2(20 BYTE),
USER_EMAIL VARCHAR2(25 BYTE),
USER_MOBILE VARCHAR2(20 BYTE),
USER_PHONE VARCHAR2(20 BYTE),
USER_STATUS VARCHAR2(20 BYTE),
CREATE_USER VARCHAR2(100 BYTE),
CREATION_DATE DATE,
CREATE_TERMINAL VARCHAR2(100 BYTE),
MODIFY_USER VARCHAR2(100 BYTE),
MODIFICATION_DATE DATE,
MODIFY_TERMINAL VARCHAR2(100 BYTE),
PASSWORD_EXPIRY_DATE DATE,
MENU_GROUP_ID NUMBER(3),
COMP_CODE NUMBER(2)
)
TABLESPACE USERS
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
NOCOMPRESS
NOCACHE
NOPARALLEL
MONITORING
/

CREATE TABLE USER_SESSION


(
ID NUMBER,
USERNAME VARCHAR2(50 BYTE),
SESSION_CREATION_TIME DATE,
SESSION_DESTROY_TIME DATE,
SESSION_DESTROY_TYPE VARCHAR2(10 BYTE),
SESSION_DESTRY_BY VARCHAR2(50 BYTE),
SESSION_CREATION_TERMINAL VARCHAR2(100 BYTE)
)
TABLESPACE USERS
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
NOCOMPRESS
NOCACHE
NOPARALLEL
MONITORING
/

CREATE TABLE MENU_GROUP


(
ID NUMBER,
GROUP_NAME VARCHAR2(50 BYTE) NOT NULL
)
TABLESPACE USERS
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
NOCOMPRESS
NOCACHE
NOPARALLEL
MONITORING
/

CREATE TABLE MENU


(
ID NUMBER,
GROUP_ID NUMBER,
MENU_NAME VARCHAR2(50 BYTE),
PARENT_ID NUMBER,
ACTION_ID NUMBER
)
TABLESPACE USERS
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
NOCOMPRESS
NOCACHE
NOPARALLEL
MONITORING
/

CREATE TABLE MENU_ACTION


(
ID NUMBER,
ACTION_NAME VARCHAR2(100 BYTE),
ACTION_URL VARCHAR2(100 BYTE) NOT NULL
)
TABLESPACE USERS
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
NOCOMPRESS
NOCACHE
NOPARALLEL
MONITORING
/

CREATE TABLE COMPANY_INFO


(
COMP_CODE NUMBER(2),
COMP_NAME VARCHAR2(50 BYTE) NOT NULL,
COMP_SNAME VARCHAR2(10 BYTE),
COMP_ADDRESS VARCHAR2(200 BYTE) NOT NULL,
COMP_PHONE VARCHAR2(30 BYTE) NOT NULL,
COMP_FAX VARCHAR2(25 BYTE),
COMP_EMAIL VARCHAR2(40 BYTE) NOT NULL,
COMP_WEB VARCHAR2(25 BYTE),
COMP_LOGO LONG RAW,
COMP_NAME_BANGLA VARCHAR2(100 BYTE),
COMP_ADDRESS_BANGLA VARCHAR2(100 BYTE),
AUTH_SIG BLOB,
GROUP_ID NUMBER
)
TABLESPACE USERS
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
NOCOMPRESS
LOB (AUTH_SIG) STORE AS
( TABLESPACE USERS
ENABLE STORAGE IN ROW
CHUNK 8192
RETENTION
NOCACHE
INDEX (
TABLESPACE USERS
STORAGE (
INITIAL 64K
NEXT 1
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
))
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
)
NOCACHE
NOPARALLEL
MONITORING
/

CREATE UNIQUE INDEX BUYER_INFO_PK ON BUYER_INFO


(ID)
LOGGING
TABLESPACE USERS
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
NOPARALLEL
/

CREATE UNIQUE INDEX BUYER_INFO_U01 ON BUYER_INFO


(BUYER_CODE)
LOGGING
TABLESPACE USERS
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
NOPARALLEL
/

CREATE UNIQUE INDEX COLOR_INFO_PK ON COLOR_INFO


(COLOR_CODE)
LOGGING
TABLESPACE USERS
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
NOPARALLEL
/

CREATE UNIQUE INDEX COLOR_INFO_U01 ON COLOR_INFO


(COLOR_NAME)
LOGGING
TABLESPACE USERS
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
NOPARALLEL
/

CREATE UNIQUE INDEX COMPANY_INFO_PK ON COMPANY_INFO


(COMP_CODE)
LOGGING
TABLESPACE USERS
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
NOPARALLEL
/

CREATE UNIQUE INDEX COUNTRY_INFO_PK ON COUNTRY_INFO


(ID)
LOGGING
TABLESPACE USERS
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
NOPARALLEL
/

CREATE UNIQUE INDEX COUNTRY_INFO_U01 ON COUNTRY_INFO


(COUNTRY_CODE)
LOGGING
TABLESPACE USERS
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
NOPARALLEL
/

CREATE UNIQUE INDEX CURRENCY_PK ON CURRENCY


(CURRENCY_CODE)
LOGGING
TABLESPACE USERS
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
NOPARALLEL
/

CREATE UNIQUE INDEX EVENT_PK ON EVENT


(EVENT_CODE)
LOGGING
TABLESPACE USERS
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
NOPARALLEL
/

CREATE UNIQUE INDEX MENU_ACTION_PK ON MENU_ACTION


(ID)
LOGGING
TABLESPACE USERS
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
NOPARALLEL
/

CREATE UNIQUE INDEX MENU_GROUP_PK ON MENU_GROUP


(ID)
LOGGING
TABLESPACE USERS
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
NOPARALLEL
/

CREATE UNIQUE INDEX MENU_PK ON MENU


(ID)
LOGGING
TABLESPACE USERS
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
NOPARALLEL
/

CREATE UNIQUE INDEX ORDER_DETAILS_PK ON ORDER_DETAILS


(ID)
LOGGING
TABLESPACE USERS
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
NOPARALLEL
/
CREATE UNIQUE INDEX ORDER_MASTER_PK ON ORDER_MASTER
(ID)
LOGGING
TABLESPACE USERS
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
NOPARALLEL
/

CREATE UNIQUE INDEX RIGHTS_PK ON RIGHTS


(ID)
LOGGING
TABLESPACE USERS
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
NOPARALLEL
/

ALTER TABLE COUNTRY_INFO ADD (


CONSTRAINT COUNTRY_INFO_PK
PRIMARY KEY
(ID)
USING INDEX
TABLESPACE USERS
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
),
CONSTRAINT COUNTRY_INFO_U01
UNIQUE (COUNTRY_CODE)
USING INDEX
TABLESPACE USERS
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
))
/

ALTER TABLE BUYER_INFO ADD (


CONSTRAINT BUYER_INFO_PK
PRIMARY KEY
(ID)
USING INDEX
TABLESPACE USERS
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
),
CONSTRAINT BUYER_INFO_U01
UNIQUE (BUYER_CODE)
USING INDEX
TABLESPACE USERS
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
))
/

ALTER TABLE ORDER_MASTER ADD (


CONSTRAINT ORDER_MASTER_PK
PRIMARY KEY
(ID)
USING INDEX
TABLESPACE USERS
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
))
/

ALTER TABLE COLOR_INFO ADD (


CONSTRAINT COLOR_INFO_PK
PRIMARY KEY
(COLOR_CODE)
USING INDEX
TABLESPACE USERS
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
),
CONSTRAINT COLOR_INFO_U01
UNIQUE (COLOR_NAME)
USING INDEX
TABLESPACE USERS
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
))
/

ALTER TABLE CURRENCY ADD (


CONSTRAINT CURRENCY_PK
PRIMARY KEY
(CURRENCY_CODE)
USING INDEX
TABLESPACE USERS
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
))
/

ALTER TABLE ORDER_DETAILS ADD (


CONSTRAINT ORDER_DETAILS_PK
PRIMARY KEY
(ID)
USING INDEX
TABLESPACE USERS
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
))
/

ALTER TABLE EVENT ADD (


CONSTRAINT EVENT_PK
PRIMARY KEY
(EVENT_CODE)
USING INDEX
TABLESPACE USERS
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
))
/

ALTER TABLE RIGHTS ADD (


CONSTRAINT RIGHTS_PK
PRIMARY KEY
(ID)
USING INDEX
TABLESPACE USERS
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
))
/

ALTER TABLE MENU_GROUP ADD (


CONSTRAINT MENU_GROUP_PK
PRIMARY KEY
(ID)
USING INDEX
TABLESPACE USERS
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
))
/

ALTER TABLE MENU ADD (


CONSTRAINT MENU_PK
PRIMARY KEY
(ID)
USING INDEX
TABLESPACE USERS
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
))
/

ALTER TABLE MENU_ACTION ADD (


CONSTRAINT MENU_ACTION_PK
PRIMARY KEY
(ID)
USING INDEX
TABLESPACE USERS
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
))
/

ALTER TABLE COMPANY_INFO ADD (


CONSTRAINT COMPANY_INFO_PK
PRIMARY KEY
(COMP_CODE)
USING INDEX
TABLESPACE USERS
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
))
/

ALTER TABLE ORDER_DETAILS ADD (


CONSTRAINT ORDER_DETAILS_R01
FOREIGN KEY (OM_ID)
REFERENCES ORDER_MASTER (ID))
/

ALTER TABLE USER_INFO ADD (


CONSTRAINT FK_COMPANY
FOREIGN KEY (COMP_CODE)
REFERENCES COMPANY_INFO (COMP_CODE))
/

ALTER TABLE MENU ADD (


CONSTRAINT MENU_R01
FOREIGN KEY (GROUP_ID)
REFERENCES MENU_GROUP (ID),
FOREIGN KEY (ACTION_ID)
REFERENCES MENU_ACTION (ID),
CONSTRAINT MENU_R02
FOREIGN KEY (PARENT_ID)
REFERENCES MENU (ID))
/

You might also like