팀원 모집 커뮤니티
테이블 (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