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)