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