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