Cafe
Tables (6)
Cafe (Office)
- id (Key2) — Numeric — Primary key — NOT NULL
- stampid (Key) — Numeric — Foreign key → Stamp.id — NOT NULL
- cafeName (Field) — String(50)
- location (Field2) — String(100)
- businessNum (Field3) — String(20)
Customer
- id (Field2) — Numeric — Primary key
- stampid (Key) — Numeric — Foreign key → Stamp.id — NOT NULL
- cafeid (Key2) — Numeric — Foreign key → Cafe.id — NOT NULL
- custPhone (Field) — String(13)
Owner
- id (Key) — Numeric — Primary key — NOT NULL
- cafeid (Key2) — Numeric — Foreign key → Cafe.id — NOT NULL
- email (Field2) — String(50) — NOT NULL
- userid (Field) — Stirng(20) — NOT NULL
- password (Field3) — String(100) — NOT NULL
- name (Field4) — Stirng(20) — NOT NULL
- ownPhone (Field5) — String(13) — NOT NULL
- Office-Phone (Field6) — String(13)
- exporeDate (Field8) — Date
- Maneger (Field7) — Boolean
QnA (Untitled)
- id (Key) — Numeric — Primary key — NOT NULL
- Ownerid (Key2) — Numeric — Foreign key → Owner.id — NOT NULL
- question (Field) — String(300)
- Manegerid (Field2) — Number + Maneger:ture
Solution (Untitled2)
- id (Key) — Numeric — Primary key — NOT NULL
- Manegerid (Key2) — Numeric — Foreign key → Owner.id — NOT NULL
- comment (Field) — String(300)
- Field2
Stamp
- id (Key) — Numeric — Primary key — NOT NULL
- Field