team_project
Tables (15)
BOARD (Untitled4)
- board_boardid (pk) — int — Primary key — NOT NULL
- board_title (Field) — varchar
- board_content (Field2) — varchar
- board_imageurl (Field3) — varchar
- board_viewcount (Field4) — int
- board_ratingavg (Field5) — double
- board_likecount (Field6) — int
- board_createdat (Field7) — varchar
- board_updatedat (Field8) — varchar
- member_id (pk2) — int — Foreign key → Member.member_id — NOT NULL
- category_id (pk3) — int — Foreign key → CATEGORY.category_id — NOT NULL
BOARD_LIKE (Untitled5)
- board_likeid (pk) — int — Primary key — NOT NULL
- board_createdat (Field) — varchar
- member_id (pk2) — int — Foreign key → Member.member_id — NOT NULL
- board_boardid (pk3) — int — Foreign key → BOARD.board_boardid — NOT NULL
BOOKMARK (Untitled6)
- bookmark_id (pk) — int — Primary key — NOT NULL
- member_id (pk2) — int — Foreign key → Member.member_id — NOT NULL
- board_boardid (pk3) — int — Foreign key → BOARD.board_boardid — NOT NULL
- bookmark_created_at (Field) — varchar
CATEGORY (Untitled2)
- category_id (pk) — int — Primary key — NOT NULL
- category_name (Field) — varchar
- category_description (Field2) — varchar
- category_createdat (Field3) — varchar
- member_id (pk2) — int — Foreign key → Member.member_id — NOT NULL
COMMENT (Untitled9)
- comment_id (PK) — int — Primary key — NOT NULL
- comment_content (Field) — varchar
- comment_is_deleted (Field2) — boolean
- comment_created_at (Field3) — varchar
- comment_update_at (Field4) — varchar
- board_boardid (pk) — int — Foreign key → BOARD.board_boardid — NOT NULL
- member_id (pk2) — int — Foreign key → Member.member_id — NOT NULL
- parent_id(자기참조) (PK3) — int — Foreign key → COMMENT.comment_id — NOT NULL
MEMBER_PREFERENCE (Untitled3)
- preference_id (Key) — int — Primary key — NOT NULL
- preference_cratedat (Field) — varchar
- category_id (pk) — int — Foreign key → CATEGORY.category_id — NOT NULL
- member_id (pk2) — int — Foreign key → Member.member_id — NOT NULL
Member (Untitled)
- member_id (pk) — int — Primary key — NOT NULL
- member_loginid (Field1) — varchar
- member_password (Field2) — varchar
- member_name (Field3) — varchar
- member_email (Field4) — varchar
- member_phone (Field5) — varchar
- member_point (Field6) — int
- member_warningcnt (Field7) — int
- member_role (Field8) — varchar
- member_status (Field9) — varchar
- member_createdat (Field10) — varchar
- member_updatedat (Field11) — varchar
POINT_HISTORY (Untitled14)
- point_history_id (pk) — int — Primary key — NOT NULL
- member_id (pk2) — int — Foreign key → Member.member_id — NOT NULL
- point_history_type (Field) — varchar
- point_history_amount (Field2) — int
- point_history_description (Field3) — varchar
- point_history_created_at (Field4) — varchar
QUIZ (Untitled7)
- quiz_id (pk) — varchar — Primary key — NOT NULL
- quiz_question (Field) — varchar
- quiz_option1 (Field2) — varchar
- quiz_option2 (Field3) — varchar
- quiz_option3 (Field4) — varchar
- quiz_option4 (Field5) — varchar
- quiz_answer (Field6) — varchar
- quiz_explanation (Field7) — varchar
- quiz_created_at (Field8) — varchar
QUIZ_ATTEMPT (Untitled8)
- quiz_attempt_id (pk) — int — Primary key — NOT NULL
- quiz_attempt_is_correct (Field) — boolean
- quiz_attempt_point (Field2) — int
- quiz_attempt_attempt_date (Field3) — varchar
- quiz_attempt_created_at (Field4) — varchar
- quiz_id (pk2) — varchar — Foreign key → QUIZ.quiz_id — NOT NULL
- member_id (pk3) — int — Foreign key → Member.member_id — NOT NULL
UPGRADE_REQUEST
- upgrade_request_id (pk) — int — Primary key — NOT NULL
- member_id (pk2) — int — Foreign key → Member.member_id — NOT NULL
- upgrade_request_status (Field) — varchar
- upgrade_request_admin_id (Field2) — int
- upgrade_request_created_at (Field3) — varchar
- upgrade_request_updated_at (Field4) — varchar
WARNING (Untitled13)
- warning_id (pk) — int — Primary key — NOT NULL
- member_id (pk2) — int — Foreign key → Member.member_id — NOT NULL
- warning_reason (Field) — varchar
- warning_created_at (Field2) — varchar
chat_message (Untitled12)
- chat_message_id (Key) — id — Primary key — NOT NULL
- chatromm_id (pk) — int — Foreign key → chatroom.chatromm_id — NOT NULL
- member_id (pk2) — int — Foreign key → Member.member_id — NOT NULL
- chat_message_content (Field) — varchar
- chat_message_created_at (Field2) — varchar
chatroom (Untitled11)
- chatromm_id (pk) — int — Primary key — NOT NULL
- chatroom_title (Field) — varchar
- chatroom_max_users (Field2) — int
- chatroom_status (Field3) — varchar
- charoom_created_at (Field4) — varchar
- charoom_updated_at (Field5) — varchar
- member_id (pk2) — int — Foreign key → Member.member_id — NOT NULL
comment_like (Untitled10)
- comment_like_id (pk) — int — Primary key — NOT NULL
- comment_created_at (Field) — varchar
- comment_id (PK) — int — Foreign key → COMMENT.comment_id — NOT NULL
- member_id (pk2) — int — Foreign key → Member.member_id — NOT NULL