You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
40 lines
1.3 KiB
40 lines
1.3 KiB
CREATE TABLE SCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.156)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=CHIPMOS))).otb_role (
|
|
guid char(36),
|
|
create_user_guid char(36),
|
|
modify_user_guid char(36),
|
|
active_flag char(1) DEFAULT '',
|
|
create_date date DEFAULT (sysdate),
|
|
modify_date date DEFAULT (sysdate),
|
|
role_id varchar2(16),
|
|
CONSTRAINT PK_otb_role PRIMARY KEY (guid)
|
|
);
|
|
|
|
CREATE TABLE SCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.156)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=CHIPMOS))).otb_user (
|
|
guid char(36),
|
|
role_guid char(36),
|
|
create_user_guid char(36),
|
|
modify_user_guid char(36),
|
|
active_flag char(1) DEFAULT '',
|
|
create_date date DEFAULT (sysdate),
|
|
email varchar2(64),
|
|
mobile varchar2(15),
|
|
modify_date date DEFAULT (sysdate),
|
|
tel varchar2(20),
|
|
user_id nvarchar2(16) NOT NULL,
|
|
user_name nvarchar2(32),
|
|
CONSTRAINT PK_otb_user PRIMARY KEY (guid)
|
|
);
|
|
|
|
CREATE TABLE SCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.156)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=CHIPMOS))).otb_session (
|
|
guid char(36),
|
|
create_user_guid char(36),
|
|
modify_user_guid char(36),
|
|
active_flag char(1) DEFAULT '',
|
|
create_date date DEFAULT (sysdate),
|
|
modify_date date DEFAULT (sysdate),
|
|
CONSTRAINT PK_otb_session PRIMARY KEY (guid)
|
|
);
|
|
|
|
|
|
|
|
|