1stweek
Tables (6)
Food (Untitled5)
- Key — bigint — Primary key — NOT NULL
- Field
Food_Prefer (Untitled6)
- Key — bigint — Primary key — NOT NULL
- Key (Key2) — bigint — Foreign key → Member.Key — NOT NULL
- Key (Key3) — bigint — Foreign key → Food.Key — NOT NULL
- Field
Member (Untitled)
- Key — bigint — Primary key — NOT NULL
- Field — varchar(10)
- Field2 — enum
- Field3 — varchar(20)
- Field4 — varchar(1)
- Field5
Mission (Untitled2)
- Key — bigint — Primary key — NOT NULL
- Key (Key2) — bigint — Foreign key → Member.Key — NOT NULL
- Field2 — bigint
- (Field) — bigint
- Field3 — text
- Field4 — bigint
- Field5 — enum
Restaurant (Untitled4)
- Key — bigint — Primary key — NOT NULL
- Key (Key2) — bigint — Foreign key → Mission.Key — NOT NULL
- Key (Key22) — bigint — Foreign key → Mission.Key — NOT NULL
- Field — varchar(10)
Review (Untitled3)
- Key — varchar(5) — Primary key — NOT NULL
- Key (Key2) — bigint — Foreign key → Restaurant.Key — NOT NULL
- Key (Key22) — bigint — Foreign key → Restaurant.Key — NOT NULL
- Key (Key222) — bigint — Foreign key → Restaurant.Key — NOT NULL
- Field — DateTIme
- Field2 — text