BoyFriend

Tables (8)

Boyfriend (Untitled)

  • primary key (bf_id) — int — Primary key — NOT NULL
  • (Field) — varchar
  • (Field2) — int
  • (Field3) — varchar
  • (Field4) — int

CAFE (Untitled4)

  • primary key (Key) — int — Primary key — NOT NULL
  • (Field) — varchar
  • (Field2) — varchar
  • (Field3) — varchar2

CUSTOMER (Untitled5)

  • primary key (Key) — int — Primary key — NOT NULL
  • (Field) — varchar
  • (Field2) — varchar
  • (Field3) — varchar2

Place (Untitled2)

  • primary key (place_id) — int — Primary key — NOT NULL
  • (Field) — varchar
  • (Field2) — varchar
  • (Field3) — boolean

RESERVATION (Untitled7)

  • primary key (Key) — int — Primary key — NOT NULL
  • foreign key (Key2) — int — Primary key — NOT NULL
  • foreign key (Key3) — int — Primary key — NOT NULL
  • (Field) — date
  • (Field2) — int
  • Field3 — int
  • Field4 — boolean
  • Field5 — int
  • Field6 — int

REVIEW (Untitled8)

  • primary key (Key) — int — Primary key — NOT NULL
  • foreign key (Key2) — int — Primary key — NOT NULL
  • Field — int
  • Field2 — varchar
  • Field3 — varchar

THEME (Untitled6)

  • primary key (Key) — int — Primary key — NOT NULL
  • foreign key (Key2) — int — Primary key — NOT NULL
  • (Field) — varchar
  • (Field2) — int
  • (Field3) — varchar
  • (Field4) — int
  • (Field5) — int

schedule (Untitled3)

  • primary (Key) — int — Primary key — NOT NULL
  • foreign (Key2) — int — Primary key — NOT NULL
  • foreign (Key3) — int — Primary key — NOT NULL
  • (Field) — date
  • (Field2) — int
  • (Field3) — text
  • primary key (bf_id) — int — Foreign key → Boyfriend.primary key — NOT NULL
  • primary (place_id) — int — Foreign key → Place.primary key — NOT NULL