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