sample
Tables (6)
Classic (Classic_receipt)
- Key (classic_seq) — BIGINT — Primary key — NOT NULL
- Key (barcode) — BIGINT — Primary key — NOT NULL
- Field (recipe) — BIGSTRING
- Field1 (calories) — Double
- Key (Type_seq) — BIGINT — Foreign key → Type.Key — NOT NULL
- Key (user_seq) — BIGINT — Foreign key → Type.Key — NOT NULL
Pescatarian (Pescatarian_receipt)
- Key (classic_seq) — BIGINT — Primary key — NOT NULL
- Key (barcode) — BIGINT — Primary key — NOT NULL
- Field (recipe) — BIGSTRING
- Field1 (calories) — Double
- Key (Type_seq) — BIGINT — Foreign key → Type.Key — NOT NULL
- Key (user_seq) — BIGINT — Foreign key → Type.Key — NOT NULL
Type (Filtered Type)
- Key (Type_seq) — BIGINT — Primary key — NOT NULL
- Key (user_seq) — BIGINT — Foreign key → users.user_id — NOT NULL
- Field (Classic) — VARCHAR(50)
- Field1 (Vegetarian) — VARCHAR(50)
- Field2 (Pescatarian) — VARCHAR(50)
- Field3 (Vegan) — VARCHAR(50)
Vegan (Vegan_receipt)
- Key (classic_seq) — BIGINT — Primary key — NOT NULL
- Key (barcode) — BIGINT — Primary key — NOT NULL
- Field (recipe) — BIGSTRING
- Field2 (calories) — Double
- Key (Type_seq) — BIGINT — Foreign key → Type.Key — NOT NULL
- Key (user_seq) — BIGINT — Foreign key → Type.Key — NOT NULL
Vegetarain (Vegetarian_receipt)
- Key (classic_seq) — BIGINT — Primary key — NOT NULL
- Key (barcode) — BIGINT — Primary key — NOT NULL
- Field (recipe) — BIGSTRING
- Field1 (calories) — Double
- Key (Type_seq) — BIGINT — Foreign key → Type.Key — NOT NULL
- Key (user_seq) — BIGINT — Foreign key → Type.Key — NOT NULL
users (mem)
- user_id (mem_id) — NOT NULL — Primary key — NOT NULL
- user_id (mem_username)
- user_pw (mem_password)
- user_gender (mem_gender)
- user_email (mem_email)
- user_name (mem_name)
- user_phone (mem_phone)
- user_type (mem_type)
- user_height (mem_height)
- user_weight (mem_weight)