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