팀원 모집 커뮤니티

테이블 (9)

Apply (Untitled7)

  • apply_id — NUMBER — 기본 키 — NOT NULL
  • board_id — NUMBER — 외래 키 → BOARD.board_id — NOT NULL
  • user_id — NUMBER — 외래 키 → BOARD.user_id — NOT NULL
  • apply_users — NUMBER — NOT NULL
  • apply_userdeposit — NUMBER — NOT NULL

BOARD (Untitled2)

  • board_id — NUMBER — 기본 키 — NOT NULL
  • user_id — NUMBER — 외래 키 → User.user_id — NOT NULL
  • board_title — VARCHAR — NOT NULL
  • board_content — VARCHAR
  • board_startdate — DATE — NOT NULL
  • board_enddate — DATE — NOT NULL
  • board_recruits — NUMBER — NOT NULL
  • board_deposit — NUMBER — NOT NULL
  • board_date — DATE — NOT NULL
  • board_count — NUMBER — NOT NULL
  • board_complete — BOOLEAN — NOT NULL
  • board_type — VARCHAR — NOT NULL

COMMENT (Untitled3)

  • comment_id — NUMBER — 기본 키 — NOT NULL
  • board_id — NUMBER — 외래 키 → BOARD.board_id — NOT NULL
  • user_id (user_id2) — NUMBER — 외래 키 → BOARD.user_id — NOT NULL
  • comment_userid — NUMBER — NOT NULL
  • comment_content — VARCHAR — NOT NULL
  • comment_date — DATE — NOT NULL
  • comment_recommand — NUMBER — NOT NULL
  • comment_id (comment_id2) — NUMBER — 외래 키 → COMMENT.comment_id — NOT NULL

Calendar (Untitled8)

  • calendar_id — NUMBER — 기본 키 — NOT NULL
  • room_id — NUMBER — 외래 키 → Room.room_id — NOT NULL
  • user_id — NUMBER — 외래 키 → Room.user_id — NOT NULL
  • calendar_date — DATE

LANGUAGE (Untitled4)

  • language_id — NUMBER — 기본 키 — NOT NULL
  • board_id — NUMBER — 외래 키 → BOARD.board_id — NOT NULL
  • user_id — NUMBER — 외래 키 → BOARD.user_id — NOT NULL
  • language_content — VARCHAR — NOT NULL

Room (Untitled6)

  • room_id — NUMBER — 기본 키 — NOT NULL
  • apply_id — NUMBER — 외래 키 → Apply.apply_id — NOT NULL
  • board_id — NUMBER — 외래 키 → Apply.board_id — NOT NULL
  • user_id — NUMBER — 외래 키 → Apply.user_id — NOT NULL
  • room_usersid — NUMBER — NOT NULL
  • room_authority — VARCHAR — NOT NULL

TYPE (Untitled5)

  • type_id — NUMBER — 기본 키 — NOT NULL
  • board_id — NUMBER — 외래 키 → BOARD.board_id — NOT NULL
  • user_id — NUMBER — 외래 키 → BOARD.user_id — NOT NULL
  • type_content — VARCHAR — NOT NULL

User (Untitled)

  • user_id — NUMBER — 기본 키 — NOT NULL
  • user_name — VARCHAR
  • user_email — VARCHAR
  • user_passwd — VARCHAR — NOT NULL
  • user_score — NUMBER — NOT NULL
  • user_joindate — DATE — NOT NULL
  • user_deposit — NUMBER — NOT NULL

chat_message

  • chat_id — NUMBER — 기본 키 — NOT NULL
  • board_id — NUMBER — 외래 키 → BOARD.board_id — NOT NULL
  • user_id — NUMBER — 외래 키 → BOARD.user_id — NOT NULL
  • chat_message — VARCHAR — NOT NULL
  • sub_id — NUMBER — NOT NULL
  • Field