modawn

Tables (7)

discussion (토론)

  • idx (Key) — number — Primary key — NOT NULL
  • discussionCategoryIdx (Key2) — number — Foreign key → discussion_category.idx — NOT NULL
  • userIdx (Key3) — number — Foreign key → user.idx — NOT NULL
  • title (Field) — string
  • content (Field9) — text
  • status (Field2) — enum('DISCUSS', 'CLOSE')
  • createdDate (Field3) — date
  • modifiedDate (Field4) — date
  • url (Field5) — string
  • imgUrl (Field6) — string
  • startDate (Field7) — date
  • endDate (Field8) — date

discussion_category (토론 카테고리)

  • idx (Key) — number — Primary key — NOT NULL
  • type (Field) — string

discussion_like (좋아요)

  • userIdx (Key) — number — Foreign key → user.idx — NOT NULL
  • discussionIdx (Key2) — number — Foreign key → discussion.idx — NOT NULL
  • createdDate (Field) — date

opinion (의견)

  • idx (Key) — number — Primary key — NOT NULL
  • discussionIdx (Key2) — number — Foreign key → discussion.idx — NOT NULL
  • userIdx (Key3) — number — Foreign key → user.idx — NOT NULL
  • title (Field) — string
  • createdDate (Field2) — date
  • modifiedDate (Field3) — date
  • type (Field4) — enum('APPROVE', 'DISAPPROVE', 'OTHER')
  • assert (Field5) — string
  • reason (Field6) — string
  • content (Field7) — text
  • url (Field8) — string
  • imgUrl (Field9) — string

opinion_like (의견 좋아요)

  • userIdx (Key) — number — Foreign key → user.idx — NOT NULL
  • opinionIdx (Key2) — number — Foreign key → opinion.idx — NOT NULL
  • createdDate (Field) — date

opinion_reply (의견 댓글)

  • idx (Key) — number — Primary key — NOT NULL
  • userIdx (Key3) — number — Foreign key → user.idx — NOT NULL
  • opinionIdx (Key2) — number — Foreign key → opinion.idx — NOT NULL
  • content (Field) — text
  • opinionType (Field2) — enum('APPROVE', 'DISAPPROVE', 'OTHER')
  • createdDate (Field3) — date
  • modifiedDate (Field4) — date

user (유저)

  • idx (Key) — number — Primary key — NOT NULL
  • name (Field) — string
  • nickname (Field2) — string
  • id (Field3) — string
  • email (Field4) — string
  • encryptedPassword (Field5) — string
  • createdDate (Field6) — date
  • modifiedDate (Field7) — date