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)