Advertisement
MatthijsFontys

Creating tacodel db no constrains V1

Apr 7th, 2020
828
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.71 KB | None | 0 0
  1. CREATE TABLE account(
  2.     id INT PRIMARY KEY IDENTITY,
  3.     passHash VARCHAR(255),
  4.     salt VARCHAR(255),
  5.     [ROLE] VARCHAR(255)
  6. );
  7.  
  8. CREATE TABLE customer(
  9.     id INT PRIMARY KEY IDENTITY,
  10.     account_id INT,
  11.     first_name VARCHAR(255),
  12.     last_name VARCHAR(255)
  13. );
  14.  
  15. CREATE TABLE menu_product(
  16.     id INT PRIMARY KEY IDENTITY,
  17.     base_name VARCHAR(255),
  18.     base_price DECIMAL,
  19.     category VARCHAR(255),
  20.     img_url VARCHAR(255)
  21. );
  22.  
  23. CREATE TABLE modification (
  24.     id INT PRIMARY KEY IDENTITY,
  25.     [name] VARCHAR(255)
  26. );
  27.  
  28. CREATE TABLE menu_product_to_modification(
  29.     menu_product_id INT,
  30.     modification_id INT,
  31.     [priority] tinyint
  32. );
  33.  
  34. CREATE TABLE choice (
  35.     id INT PRIMARY KEY IDENTITY,
  36.     modification_id INT,
  37.     [name] VARCHAR(255),
  38.     prefix VARCHAR(255),
  39.     price DECIMAL
  40. );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement