52 lines
1.9 KiB
Plaintext
52 lines
1.9 KiB
Plaintext
CREATE TABLE HIGHWAY_EXCHANGE.T_SALESPROMOTE
|
|
(
|
|
SALESPROMOTE_ID NUMBER(9,0) NOT NULL,
|
|
SERVERPARTCODE VARCHAR2(10),
|
|
SHOPCODE VARCHAR2(6),
|
|
MACHINECODE VARCHAR2(6),
|
|
SALESPROMOTE_STARTDATE TIMESTAMP(7),
|
|
SALESPROMOTE_ENDDATE TIMESTAMP(7),
|
|
SALESPROMOTE_TYPE NUMBER(8,0),
|
|
SALESPROMOTE_NAME VARCHAR2(2000),
|
|
THRESHOLD_AMOUNT NUMBER(16,2),
|
|
DISCOUNT_RATE NUMBER(16,2),
|
|
SALESPROMOTE_VIP NUMBER(1,0),
|
|
FLAG NUMBER(4,0),
|
|
TICKET_PREFIX VARCHAR2(50),
|
|
SALESPROMOTE_DATE TIMESTAMP(7),
|
|
SALESPROMOTE_DESC VARCHAR2(2000)
|
|
)
|
|
PCTFREE 10
|
|
MAXTRANS 255
|
|
TABLESPACE HIGHWAY_EXCHANGE
|
|
STORAGE(INITIAL 64K MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT)
|
|
NOCACHE
|
|
LOGGING
|
|
/
|
|
CREATE TABLE HIGHWAY_EXCHANGE.T_CONFIGURATION
|
|
(
|
|
CONFIGURATION_ID NUMBER(9,0) NOT NULL,
|
|
CONFIGURATION_DATE TIMESTAMP(7),
|
|
SERVERPARTCODE VARCHAR2(10),
|
|
SHOPCODE VARCHAR2(6),
|
|
MACHINECODE VARCHAR2(6),
|
|
MACADDRESS VARCHAR2(50),
|
|
CONFIGURATION_NAME VARCHAR2(2000),
|
|
CONFIGURATION_VALUES VARCHAR2(2000),
|
|
CONFIGURATION_DESC VARCHAR2(2000),
|
|
FLAG NUMBER(1,0),
|
|
CONSTRAINT PK_CONFIGURATION UNIQUE (MACADDRESS, CONFIGURATION_NAME) USING INDEX
|
|
PCTFREE 10
|
|
INITRANS 2
|
|
MAXTRANS 255
|
|
TABLESPACE HIGHWAY_EXCHANGE
|
|
STORAGE(INITIAL 64K MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT)
|
|
LOGGING
|
|
)
|
|
PCTFREE 10
|
|
MAXTRANS 255
|
|
TABLESPACE HIGHWAY_EXCHANGE
|
|
STORAGE(INITIAL 64K MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT)
|
|
NOCACHE
|
|
LOGGING
|
|
/ |