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