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