0

Tables (7)

BAR (Untitled4)

  • B_NAME (Field) — VARCHAR(50) — Primary key
  • ID (id) — VARCHAR(20) — Foreign key → MEMBER.ID
  • M_ID (Field3) — VARCHAR(20)
  • DETAIL (Field2) — VARCHAR(100)
  • IMAGE (Field4) — IMAGE
  • YEAR (Field5) — NUMERIC(4,0)
  • MONTH (Field6) — NUMERIC(2,0)
  • DAY (Field7) — NUMERIC(2,0)

B_REVIEW (CopyOfUntitled3)

  • B_NAME (Field4) — VARCHAR(50) — Foreign key → BAR.B_NAME
  • ID (id) — VARCHAR(20) — Foreign key → BAR.ID
  • C_NAME (Field) — VARCHAR(20)
  • M_ID (Field2) — VARCHAR(20)
  • DETAIL (Field3) — VARCHAR(20)
  • YEAR (Field5) — NUMERIC(4,0)
  • MONTH (Field6) — NUMERIC(2,0)
  • DAY (Field7) — NUMERIC(2,0)

COCKTAIL (cocktail)

  • M_ID (n_name) — VARCHAR(20) — Primary key
  • ID (id) — VARCHAR(20) — Foreign key → MEMBER.ID
  • C_NAME (c_name) — VARCHAR(20)
  • DETAIL (detail) — VARCHAR(50)
  • RECIPE (recipe) — VARCHAR(20)
  • PROOF (Field) — VARCHAR(20)
  • YEAR (Field2) — NUMERIC(4,0)
  • MONTH (Field3) — NUMERIC(2,0)
  • DAY (Field4) — NUMERIC(2,0)
  • IMAGE (Field5) — IMAGE

C_REVIEW (Untitled3)

  • R_NAME (Field4) — VARCHAR(20) — Primary key
  • ID (id) — VARCHAR(20) — Foreign key → COCKTAIL.ID
  • C_NAME (Field) — VARCHAR(20)
  • M_ID (Field2) — VARCHAR(20)
  • DETAIL (Field3) — VARCHAR(20)
  • YEAR (Field5) — NUMERIC(4,0)
  • MONTH (Field6) — NUMERIC(2,0)
  • DAY (Field7) — NUMERIC(2,0)

INGREDIENT (Untitled2)

  • I_NAME (Field) — VARCHAR(30) — Primary key
  • DETAIL (Field2) — VARCHAR(50)
  • IMAGE (Field3) — IMAGE

MEMBER (member)

  • ID (id) — VARCHAR(20) — Primary key
  • PW (pw) — VARCHAR(20)
  • NAME (name) — VARCHAR(20)

RECIPE (Untitled)

  • R_NAME (Field) — VARCHAR(30) — Primary key
  • RECIPE (id) — VARCHAR(20) — Foreign key → COCKTAIL.ID
  • I_NAME (Field4) — VARCHAR(30) — Foreign key → INGREDIENT.I_NAME
  • I_NAME (Field2) — VARCHAR(30)
  • DETAIL (Field3) — VARCHAR(30)