cafeSNS
Tables (9)
Cafe (Untitled2)
- id (Key) — Long — Primary key — NOT NULL
- ownerid (Key2) — Long — Foreign key → User.id — NOT NULL
- cafename (Field) — varchar
- address (Field2) — varchar
- addressdetail (\) — varchar
- zonenum (Field3) — varchar
- intro (Field4) — text
- notice (Field5) — text
- delivery (Field6) — boolean
- opentime (Field7) — varchar
- closetime (Field8) — varchar
- latitude (Field9) — Float
- longitude (Field10) — Float
Comment (Untitled8)
- id (Key) — Long — Primary key — NOT NULL
- postid (Key2) — Long — Foreign key → Post.id — NOT NULL
- userid (Key3) — Long — Foreign key → User.id — NOT NULL
- contents (Field) — Text
- createdAt (Field4) — LocalDate
- modifiedAt (Field3) — LocalDate
Hashtag (Untitled7)
- id (Key) — Long — Primary key — NOT NULL
- postid (Key2) — Long — Foreign key → Post.id — NOT NULL
- hashtag (Field) — varchar
Image (Untitled6)
- id (Key) — Long — Primary key — NOT NULL
- postid (Key2) — Long — Foreign key → Post.id — NOT NULL
- img (Field) — Text
Like (Untitled9)
- 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
Menu (Untitled3)
- id (Key) — Long — Primary key — NOT NULL
- cafeid (Key2) — Long — Foreign key → Cafe.id — NOT NULL
- category (Field) — varchar
- menuimg (Field2) — text
- menuname (Field3) — varchar
- menuprice (Field4) — varchar
Post (Untitled5)
- id (Key) — Long — Primary key — NOT NULL
- cafeid (Key3) — Long — Foreign key → Cafe.id — NOT NULL
- userid (Key2) — Long — Foreign key → User.id — NOT NULL
- star (Field) — int
- contents (Field4) — text
- createdAt (Field3) — LocalDate
- modifiedAt (Field2) — LocalDate
Register (Untitled4)
- id (Key) — Long — Primary key — NOT NULL
- cafename (Field) — varchar
- address (Field2) — varchar
- addressdetail (Field3) — varchar
- zonenum (Field4) — varchar
- permit (Field5) — Boolean
- latitude (Field7) — varchar
- longitude (Field8) — varchar
User (Untitled)
- id (Key) — Long — Primary key — NOT NULL
- role (Field) — varchar
- email (Field2) — varchar
- nickname (Field3) — varchar
- password (Field4) — varchar
- businessname (Field5) — Boolean
- businessnum (Field6) — Text
- profileimg (Field7) — Text
- logoimg (Field8) — Text