cafeSNS
Tables (8)
Cafe (Untitled2)
- id (Key2) — Long — Primary key — NOT NULL
- ownerid (Key) — Long — Foreign key → User.id — NOT NULL
- cafename (Field) — varchar
- notice (Field6) — text
- delivery (Field9) — Boolean
- address (Field2) — varchar
- addressdetail (Field3) — varchar
- zonenum (Field4) — varchar
- intro (Field5) — varchar
- opentime (Field7) — varchar
- closetime (Field8) — varchar
Comment (Untitled6)
- id (Key) — Long — Primary key — NOT NULL
- userid (Key2) — Long — Foreign key → User.id — NOT NULL
- postid (Key3) — Long — Foreign key → Post.id — NOT NULL
- id (Key4) — Long — Foreign key → Post.id — NOT NULL
- content (Field) — text
- createdat (Field2) — LocalDate
- modifiedat (Field3) — LocalDate
Image (Untitled5)
- id (Key) — Long — Primary key — NOT NULL
- postid (Key2) — Long — Foreign key → Post.id — NOT NULL
- id (Key4) — Long — Foreign key → Post.id — NOT NULL
- imageurl (Field) — text
Like (Untitled7)
- id (Key) — Long — Primary key — NOT NULL
- userid (Key2) — Long — Foreign key → User.id — NOT NULL
- postid (Key3) — Long — Foreign key → Post.id — NOT NULL
- id (Key4) — Long — Foreign key → Post.id — NOT NULL
Menu (Untitled4)
- id (Key) — Long — Primary key — NOT NULL
- cafeid (Key2) — Long — Foreign key → Cafe.id — NOT NULL
- id (Key3) — Long — Foreign key → Cafe.ownerid — NOT NULL
- drinkname (Field) — varchar
- drinkimg (Field2) — text
- drinkprice (Field3) — int
- dessertname (Field4) — varchar
- dessertimg (Field5) — text
- dessertprice (Field6) — int
Post (Untitled3)
- id (Key) — Long — Primary key — NOT NULL
- userid (Key3) — Long — Foreign key → User.id — NOT NULL
- cafeid (Key2) — Long — Foreign key → Cafe.id — NOT NULL
- id (Key4) — Long — Foreign key → Cafe.ownerid — NOT NULL
- star (Field2) — int
- cafename (Field3) — varchar
- createdat (Field) — LocalDate
- modifiedat (Field4) — LocalDate
- content (Field5) — text
Register (Untitled8)
- id (Key) — Long — Primary key — NOT NULL
- cafename (Field) — varchar
- nickname (Field4) — varchar
- address (Field2) — varchar
- permit (Field7) — Boolean
- detailaddress (Field3) — varchar
- createdat (Field5) — LocalDate
- modified (Field6) — LocalDate
User (Untitled)
- id (Key) — Long — Primary key — NOT NULL
- email (Field) — varchar
- nickname (Field2) — varchar
- password (Field3) — varchar
- profileimg (Field7) — text
- role (Field4) — varchar
- businessname (Field5) — varchar
- businessnumber (Field6) — varchar