Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE account(
- id INT PRIMARY KEY IDENTITY,
- passHash VARCHAR(255),
- salt VARCHAR(255),
- [ROLE] VARCHAR(255)
- );
- CREATE TABLE customer(
- id INT PRIMARY KEY IDENTITY,
- account_id INT,
- first_name VARCHAR(255),
- last_name VARCHAR(255)
- );
- CREATE TABLE menu_product(
- id INT PRIMARY KEY IDENTITY,
- base_name VARCHAR(255),
- base_price DECIMAL,
- category VARCHAR(255),
- img_url VARCHAR(255)
- );
- CREATE TABLE modification (
- id INT PRIMARY KEY IDENTITY,
- [name] VARCHAR(255)
- );
- CREATE TABLE menu_product_to_modification(
- menu_product_id INT,
- modification_id INT,
- [priority] tinyint
- );
- CREATE TABLE choice (
- id INT PRIMARY KEY IDENTITY,
- modification_id INT,
- [name] VARCHAR(255),
- prefix VARCHAR(255),
- price DECIMAL
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement