디비고 ERD
okky erd
테이블 (7)
content (tip_content)
- id — number — 기본 키 — NOT NULL
- id (user_id) — number — 외래 키 → user.id — NOT NULL
- date_created — date — NOT NULL
- text — varchar2(4000) — NOT NULL
- Field (start_date) — date — NOT NULL
- Field (end_date) — date — NOT NULL
- Field (title) — varchar2(255)
- Field (vote_count) — number — NOT NULL — default 0
content_vote (tip_vote)
- id — number — 기본 키 — NOT NULL
- id (user_id) — number — 외래 키 → user.id — NOT NULL
- content_id — number — 외래 키 → content.id — NOT NULL
- date_created — date — NOT NULL
opinion (tip_opinion)
- id — number — 기본 키 — NOT NULL
- id (user_id) — number — 외래 키 → user.id — NOT NULL
- content_id — number — 외래 키 → content.id — NOT NULL
- comment — varchar2(4000) — NOT NULL
- date_created — date — NOT NULL
qna (qna_content)
- id — number — 기본 키 — NOT NULL
- id (user_id) — number — 외래 키 → user.id — NOT NULL
- date_created — date — NOT NULL
- text — varchar2(4000) — NOT NULL
- Field (category) — varchar2(255) — NOT NULL
- Field (title) — varchar2(255)
- Field (vote_count) — number
qna_opinion
- id — number — 기본 키 — NOT NULL
- id (content_id) — number — 외래 키 → qna.id — NOT NULL
- id (user_id) — number — 외래 키 → user.id — NOT NULL
- comment — varchar2(4000) — NOT NULL
- date_created — date — NOT NULL
- last_updated — date — NOT NULL
qna_vote
- id — number — 기본 키 — NOT NULL
- id (content_id) — number — 외래 키 → qna.id — NOT NULL
- id (user_id) — number — 외래 키 → user.id — NOT NULL
- date_created — date — NOT NULL
user
- id — number — 기본 키 — NOT NULL
- date_created — date — NOT NULL
- password — varchar2(255) — NOT NULL
- Field (email) — varchar2(255) — NOT NULL
- Field (nick_name) — varchar2(255) — NOT NULL