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