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.
49 lines
2.0 KiB
49 lines
2.0 KiB
CREATE TABLE odb_generic:otb_role(
|
|
guid char(36),
|
|
create_user_guid char(36),
|
|
modify_user_guid char(36),
|
|
active_flag char(1) DEFAULT 'Y',
|
|
create_date datetime YEAR TO SECOND DEFAULT CURRENT YEAR TO SECOND NOT NULL,
|
|
modify_date datetime YEAR TO SECOND DEFAULT CURRENT YEAR TO SECOND NOT NULL,
|
|
role_id varchar(16),
|
|
PRIMARY KEY (guid) CONSTRAINT PK_otb_role
|
|
);
|
|
|
|
CREATE TABLE odb_generic:otb_user(
|
|
guid char(36),
|
|
role_guid char(36),
|
|
create_user_guid char(36),
|
|
modify_user_guid char(36),
|
|
active_flag char(1) DEFAULT 'Y',
|
|
create_date datetime YEAR TO SECOND DEFAULT CURRENT YEAR TO SECOND NOT NULL,
|
|
email varchar(64),
|
|
mobile varchar(15),
|
|
modify_date datetime YEAR TO SECOND DEFAULT CURRENT YEAR TO SECOND NOT NULL,
|
|
tel varchar(20),
|
|
user_id nvarchar(16) NOT NULL,
|
|
user_name nvarchar(32),
|
|
PRIMARY KEY (guid) CONSTRAINT PK_otb_user
|
|
);
|
|
|
|
CREATE TABLE odb_generic:otb_session(
|
|
guid char(36),
|
|
create_user_guid char(36),
|
|
modify_user_guid char(36),
|
|
active_flag char(1) DEFAULT 'Y',
|
|
create_date datetime YEAR TO SECOND DEFAULT CURRENT YEAR TO SECOND NOT NULL,
|
|
modify_date datetime YEAR TO SECOND DEFAULT CURRENT YEAR TO SECOND NOT NULL,
|
|
PRIMARY KEY (guid) CONSTRAINT PK_otb_session
|
|
);
|
|
|
|
|
|
|
|
|
|
ALTER TABLE odb_generic:otb_session ADD CONSTRAINT FOREIGN KEY (create_user_guid) REFERENCES odb_generic:otb_user(guid);
|
|
ALTER TABLE odb_generic:otb_session ADD CONSTRAINT FOREIGN KEY (modify_user_guid) REFERENCES odb_generic:otb_user(guid);
|
|
ALTER TABLE odb_generic:otb_role ADD CONSTRAINT FOREIGN KEY (create_user_guid) REFERENCES odb_generic:otb_user(guid);
|
|
ALTER TABLE odb_generic:otb_role ADD CONSTRAINT FOREIGN KEY (modify_user_guid) REFERENCES odb_generic:otb_user(guid);
|
|
ALTER TABLE odb_generic:otb_user ADD CONSTRAINT FOREIGN KEY (role_guid) REFERENCES odb_generic:otb_role(guid);
|
|
ALTER TABLE odb_generic:otb_user ADD CONSTRAINT FOREIGN KEY (create_user_guid) REFERENCES odb_generic:otb_user(guid);
|
|
ALTER TABLE odb_generic:otb_user ADD CONSTRAINT FOREIGN KEY (modify_user_guid) REFERENCES odb_generic:otb_user(guid);
|
|
|
|
|