DONGMYUNG

Tables (8)

Answer (answer)

  • id (Key) — Long — Primary key — NOT NULL
  • content (Field) — String
  • createdate (Field2) — LocalDateTime
  • modifyDate (Field5) — LocalDateTime
  • answerLike (Field6) — AnswerLike
  • author (Key2) — SiteUser — Foreign key → SiteUser.ID — NOT NULL
  • question (Key3) — Question — Foreign key → Question.ID — NOT NULL

AnswerLike (answer_like)

  • ID (Key) — Long — Primary key — NOT NULL
  • user_id (Key2) — Long — Foreign key → SiteUser.ID — NOT NULL
  • answer_id (Key3) — Long — Foreign key → Answer.id — NOT NULL

Food (Untitled2)

  • ID (Key) — Long — Primary key — NOT NULL
  • name (Field) — String
  • ID (Key2) — Long — Foreign key → MenuFood.ID — NOT NULL

Menu (Untitled)

  • Id (Key) — Long — Primary key — NOT NULL
  • Date (Field) — LocalDate
  • Timing (Field2) — Timing
  • ID (Key2) — Long — Foreign key → MenuFood.ID — NOT NULL

MenuFood (Untitled3)

  • ID (Key) — Long — Primary key — NOT NULL
  • Menu (Field) — Menu
  • Food (Field2) — Food

PostLike (post_like)

  • ID (Key) — Long — Primary key — NOT NULL
  • user_id (Key2) — Long — Foreign key → SiteUser.ID — NOT NULL
  • question_id (Key3) — Long — Foreign key → Question.ID — NOT NULL

Question (question)

  • ID (Key) — Long — Primary key — NOT NULL
  • subject (Field) — String
  • content (Field2) — String
  • createdate (Field3) — LocalDateTime
  • answerList (Field4) — List<Answer>
  • modifyDate (Field6) — LocalDateTIme
  • postLike (Field5) — PostLike
  • author (Key2) — siteUser — Foreign key → SiteUser.ID — NOT NULL

SiteUser (site_user)

  • ID (Key) — Long — Primary key — NOT NULL
  • username (Field) — String
  • password (Field2) — String
  • email (Field3) — String