Advertisement
1HazingAU

sql execution

May 30th, 2021
1,361
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE user_customer
  2. (
  3.     user_id integer PRIMARY KEY,
  4.     name_user VARCHAR(45) NOT NULL,
  5.     age VARCHAR(45) NOT NULL,
  6.     address VARCHAR(45) NOT NULL,
  7.     gender VARCHAR(45) NOT NULL,
  8.     passport VARCHAR(45) NOT NULL,
  9.     login VARCHAR(45)
  10. );
  11.  
  12. CREATE TABLE user_operator
  13. (
  14.     user_operator_id integer PRIMARY KEY,
  15.     clinet_data VARCHAR(45) NOT NULL
  16. );
  17.  
  18. CREATE TABLE ROLE_USERS
  19. (
  20.     ROLE_USER_ID integer PRIMARY KEY,
  21.     fk_operator_id integer REFERENCES user_operator(user_operator_id) NOT NULL,
  22.     fk_user_customer integer REFERENCES user_customer(user_id) NOT NULL
  23. );
  24.  
  25. CREATE TABLE cabin
  26. (
  27.     cabin_id integer PRIMARY KEY,
  28.     number_cabin VARCHAR(45) NOT NULL,
  29.     class_cabin VARCHAR(45) NOT NULL,
  30.     floor_cabin VARCHAR(45) NOT NULL,
  31.     type_cabin VARCHAR(45) NOT NULL
  32. );
  33.  
  34. CREATE TABLE events
  35. (
  36.     events_id integer PRIMARY KEY,
  37.     type_events VARCHAR(45) NOT NULL
  38. );
  39.  
  40. CREATE TABLE event_type
  41. (
  42.     event_type_id integer PRIMARY KEY,
  43.     fk_events_id integer REFERENCES events(events_id) NOT NULL
  44. );
  45.  
  46. CREATE TABLE products
  47. (
  48.     product_id integer PRIMARY KEY,
  49.     name_product VARCHAR(45) NOT NULL,
  50.     description VARCHAR(45) NOT NULL,
  51.     start_date DATE NOT NULL,
  52.     finish_date DATE NOT NULL
  53. );
  54.  
  55. CREATE TABLE ships
  56. (
  57.     ship_id integer PRIMARY KEY,
  58.     name_ship VARCHAR(45) NOT NULL,
  59.     type_ship VARCHAR(45) NOT NULL,
  60.     capacity VARCHAR(45)
  61. );
  62.  
  63. CREATE TABLE voucher
  64. (
  65.     voucher_id integer PRIMARY KEY,
  66.     fk_product_id integer REFERENCES products(product_id) NOT NULL,
  67.     fk_ships_id integer REFERENCES ships(ship_id) NOT NULL
  68. );
  69.  
  70. CREATE TABLE order_regist
  71. (
  72.     order_regist_id integer PRIMARY KEY,
  73.     registration_date date NOT NULL,
  74.     registration_time time NOT NULL,
  75.     fk_cabin_id integer REFERENCES cabin(cabin_id) NOT NULL,
  76.     fk_event_type_id integer REFERENCES event_type(event_type_id) NOT NULL,
  77.     fk_role_id integer REFERENCES ROLE_USERS(ROLE_USER_ID) NOT NULL,
  78.     fk_voucher_id integer REFERENCES voucher(voucher_id) NOT NULL
  79. );
  80.  
  81.  
  82. CREATE TABLE ticket
  83. (
  84.     ticket_id integer PRIMARY KEY,
  85.     fk_order_id integer REFERENCES order_regist(order_regist_id) NOT NULL
  86. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement