Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE user_customer
- (
- user_id integer PRIMARY KEY,
- name_user VARCHAR(45) NOT NULL,
- age VARCHAR(45) NOT NULL,
- address VARCHAR(45) NOT NULL,
- gender VARCHAR(45) NOT NULL,
- passport VARCHAR(45) NOT NULL,
- login VARCHAR(45)
- );
- CREATE TABLE user_operator
- (
- user_operator_id integer PRIMARY KEY,
- clinet_data VARCHAR(45) NOT NULL
- );
- CREATE TABLE ROLE_USERS
- (
- ROLE_USER_ID integer PRIMARY KEY,
- fk_operator_id integer REFERENCES user_operator(user_operator_id) NOT NULL,
- fk_user_customer integer REFERENCES user_customer(user_id) NOT NULL
- );
- CREATE TABLE cabin
- (
- cabin_id integer PRIMARY KEY,
- number_cabin VARCHAR(45) NOT NULL,
- class_cabin VARCHAR(45) NOT NULL,
- floor_cabin VARCHAR(45) NOT NULL,
- type_cabin VARCHAR(45) NOT NULL
- );
- CREATE TABLE events
- (
- events_id integer PRIMARY KEY,
- type_events VARCHAR(45) NOT NULL
- );
- CREATE TABLE event_type
- (
- event_type_id integer PRIMARY KEY,
- fk_events_id integer REFERENCES events(events_id) NOT NULL
- );
- CREATE TABLE products
- (
- product_id integer PRIMARY KEY,
- name_product VARCHAR(45) NOT NULL,
- description VARCHAR(45) NOT NULL,
- start_date DATE NOT NULL,
- finish_date DATE NOT NULL
- );
- CREATE TABLE ships
- (
- ship_id integer PRIMARY KEY,
- name_ship VARCHAR(45) NOT NULL,
- type_ship VARCHAR(45) NOT NULL,
- capacity VARCHAR(45)
- );
- CREATE TABLE voucher
- (
- voucher_id integer PRIMARY KEY,
- fk_product_id integer REFERENCES products(product_id) NOT NULL,
- fk_ships_id integer REFERENCES ships(ship_id) NOT NULL
- );
- CREATE TABLE order_regist
- (
- order_regist_id integer PRIMARY KEY,
- registration_date date NOT NULL,
- registration_time time NOT NULL,
- fk_cabin_id integer REFERENCES cabin(cabin_id) NOT NULL,
- fk_event_type_id integer REFERENCES event_type(event_type_id) NOT NULL,
- fk_role_id integer REFERENCES ROLE_USERS(ROLE_USER_ID) NOT NULL,
- fk_voucher_id integer REFERENCES voucher(voucher_id) NOT NULL
- );
- CREATE TABLE ticket
- (
- ticket_id integer PRIMARY KEY,
- fk_order_id integer REFERENCES order_regist(order_regist_id) NOT NULL
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement