디비고 ref
okky erd
테이블 (4)
Untitled (board)
- Key (board_no) — number — 기본 키 — NOT NULL — primary key
- Field (user_nick) — varchar2(30) — 기본 키 — NOT NULL
- id (board_no2) — number — 외래 키 → content_vote.id — NOT NULL
- id (reply_no) — number — 외래 키 → opinion.id — NOT NULL — primary key
- Field (board_title) — varchar2(300) — NOT NULL
- Field2 (board_content) — varchar2(4000) — NOT NULL
- Field (board_read) — number — NOT NULL
content_vote (board_like)
- id (board_no) — number — 기본 키 — NOT NULL
- date_created (like_count) — number — NOT NULL
opinion (board_reply)
- id (reply_no) — number — 기본 키 — NOT NULL — primary key
- date_created (user_nick) — datetime — NOT NULL
- comment (reply_read) — number — NOT NULL
- Field (reply_content) — varchar(2000) — NOT NULL
- Field
user
- Key (user_no) — number — 기본 키 — NOT NULL
- Field (user_nick2) — varchar2(30) — 외래 키 → Untitled.Field — NOT NULL
- id (reply_no) — number — 외래 키 → opinion.id — NOT NULL — primary key
- id (board_no2) — number — 외래 키 → Untitled.id — NOT NULL
- id (reply_no2) — number — 외래 키 → Untitled.id — NOT NULL — primary key
- id (user_email) — varchar2(50) — NOT NULL — unique
- date_created (user_pw) — varchar2(30) — NOT NULL
- password (user_phone) — number — NOT NULL
- Field (user_nick) — varchar2(30) — NOT NULL
- Field (regist_date) — varchar2(11) — NOT NULL