getjob
Tables (4)
Board (게시판)
- 게시물번호 (board_no) — NUMBER — Primary key — NOT NULL
- 제목 (title) — VARCHAR2(500)
- 내용 (content) — CLOB
- 작성자아이디 (writer_id) — VARCHAR2(100)
- 작성자닉네임 (writer_nick) — VARCHAR2(100)
- 조회수 (hit) — NUMBER
- 작성일 (write_date) — DATE
CommentTb (댓글)
- 게시물번호 (board_no) — NUMBER — Foreign key → Board.게시물번호 — NOT NULL
- 댓글번호 (comment_no) — NUMBER
- 작성자닉네임 (writer_nick) — VARCHAR2(100)
- 댓글내용 (comment_content) — VARCHAR2(1000)
- 작성일 (write_date) — DATE
Member (멤버)
- 아이디 (id) — VARCHAR2(100) — Primary key — NOT NULL
- 패스워드 (pw) — VARCHAR2(100)
- 닉네임 (nick) — VARCHAR2(100)
Recommend (추천)
- 게시물번호 (board_no) — NUMBER — Foreign key → Board.게시물번호 — NOT NULL
- 작성자아이디 (writer_id) — VARCHAR2(100)