Today's Pick

Tables (9)

Answer (문의사항 답변)

  • aid (Key) — Long — Primary key — NOT NULL
  • title (Field) — String
  • content (Field2) — String
  • type (Field3) — String
  • to (Field4) — String
  • from (Field5) — String
  • regdate (Field6) — Date

Eatery (식당)

  • eid (Key) — Long — Primary key — NOT NULL
  • name (Field) — String
  • category (Field2) — String
  • latitude (Field3) — Double
  • longitude (Field4) — Double
  • address (Field5) — String
  • roadAddress (Field7) — String
  • phone (Field8) — String
  • url (Field6) — String

Favorites (즐겨찾기)

  • fid (Key) — Long — Primary key — NOT NULL
  • regdate (Field) — Date
  • uid (Key2) — Long — Foreign key → User.uid — NOT NULL
  • eid (Key3) — Long — Foreign key → Eatery.eid — NOT NULL

Inquiry (문의사항)

  • qid (Key) — Long — Primary key — NOT NULL
  • title (Field) — String
  • content (Field2) — String
  • type (Field3) — String
  • to (Field4) — String
  • from (Field5) — String
  • regdate (Field6) — Date
  • Field7

Interaction (사용자-음식점 상호작용)

  • iid (Key) — Long — Primary key — NOT NULL
  • feedback (Field) — int
  • ratings (Field2) — int
  • uid (Key2) — Long — Foreign key → User.uid — NOT NULL
  • eid (Key3) — Long — Foreign key → Eatery.eid — NOT NULL

Menu (메뉴)

  • mid (Key) — Long — Primary key — NOT NULL
  • mname (Field) — String
  • price (Field2) — int
  • eid (Key2) — Long — Foreign key → Eatery.eid — NOT NULL

Notice (공지사항)

  • nid (Key) — Long — Primary key — NOT NULL
  • title (Field) — String
  • content (Field2) — LONGTEXT
  • regdate (Field3) — Date
  • author (Field4) — String
  • views (Field5) — int

Preference (선호도)

  • pid (Key) — String — Primary key — NOT NULL
  • uid (Key2) — Long — Foreign key → User.uid — NOT NULL
  • taste (Field2) — String
  • category (Field3) — String
  • priceLevel (Field4) — int
  • purpose (Field5) — String

User (사용자)

  • uid (Key) — Long — Primary key — NOT NULL
  • username (Field) — String
  • email (Field2) — String
  • password (Field3) — String
  • role (Field4) — enum
  • birthDate (Field5) — date