teamCafe
테이블 (5)
대댓글 (reply_reply)
- Key (reply_reply_no) — number(6) — 기본 키 — NOT NULL
- Key (reply_no) — number(6) — 외래 키 → 댓글.Key — NOT NULL
- Field (user_id) — varchar2(20) — NOT NULL
- Field (user_nickname) — varchar2(20) — NOT NULL
- Field4 (content) — varchar2(500) — NOT NULL
- Field (image_name) — varchar2(100)
- Field2 (likey) — number(6)
- Field2 (write_date) — Date
댓글 (reply)
- Key (reply_no) — number(6) — 기본 키 — NOT NULL
- Key (all_board_no) — number(6) — 외래 키 → 전체게시글.Key — NOT NULL
- Field (user_id) — varchar2(20) — NOT NULL
- Field (user_nickname) — varchar2(20) — NOT NULL
- Field4 (content) — varchar2(500) — NOT NULL
- Field (image_name) — varchar2(100)
- Field2 (likey) — number(6)
- Field2 (write_date) — Date
유저 정보 (member_info)
- Key (user_id) — varchar2(20) — 기본 키 — NOT NULL
- Field (user_pw) — varchar2(20) — NOT NULL
- Field (user_nickname) — varchar2(20) — NOT NULL
- Field2 (user_grade) — varchar2(10) — NOT NULL
- Field3 (user_join_date) — Date
- Field (user_profile_image_name) — varchar2(100)
전체게시글 (all_board)
- Key (all_board_no) — number(6) — 기본 키 — NOT NULL
- Key (user_id) — varchar2(20) — 외래 키 → 유저 정보.Key — NOT NULL
- Field (user_nickname) — varchar2(20) — NOT NULL
- Field3 (title) — varchar2(50) — NOT NULL
- Field4 (content) — varchar2(500) — NOT NULL
- Field (image_name) — varchar2(100)
- Field (count) — number(6)
- Field2 (likey) — number(6)
- Field2 (write_date) — Date
- Field2 (board_type) — varchar2(20) — NOT NULL
- Field2 (sub_title) — varchar2(20)
- Field (notice_chk) — varchar2(4)
좋아요 리스트 (likey_list)
- Key (like_list) — varchar2(100) — 기본 키 — NOT NULL
- Field2 (user_id) — varchar2(20) — NOT NULL