test

Tables (24)

tbl_assigned

  • task_id — BIGINT — Foreign key → tbl_task.task_id — NOT NULL
  • user_id — BIGINT — Foreign key → tbl_user.user_id — NOT NULL

tbl_board

  • board_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → tbl_user.user_id — NOT NULL
  • study_id — BIGINT — Foreign key → tbl_study.study_id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • desc — TEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • views — INT — NOT NULL

tbl_board_file

  • board_id — BIGINT — Foreign key → tbl_board.board_id — NOT NULL
  • file_id — BIGINT — Foreign key → tbl_file.file_id — NOT NULL

tbl_board_like

  • board_id — BIGINT — Foreign key → tbl_board.board_id — NOT NULL
  • user_id — BIGINT — Foreign key → tbl_user.user_id — NOT NULL

tbl_chat_1

  • chat_id — BIGINT — Primary key — NOT NULL
  • study_id — BIGINT — Foreign key → tbl_study.study_id — NOT NULL
  • user_id — BIGINT — Foreign key → tbl_user.user_id — NOT NULL
  • message — TEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

tbl_file

  • file_id — BIGINT — Primary key — NOT NULL
  • filename — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • file_url — VARCHAR(255) — NOT NULL

tbl_location

  • location_id — BIGINT — Primary key — NOT NULL
  • parent_id — BIGINT — Foreign key → tbl_location.location_id
  • name — VARCHAR(255) — NOT NULL
  • type — ENUM('CITY', 'TOWN') — NOT NULL

tbl_member

  • study_member_id — BIGINT — Primary key — NOT NULL
  • study_id — BIGINT — Foreign key → tbl_study.study_id — NOT NULL
  • user_id — BIGINT — Foreign key → tbl_user.user_id — NOT NULL
  • message — TEXT — NOT NULL
  • status — ENUM('PENDING', 'ACCEPTED', 'REJECTED') — NOT NULL
  • request_at — TIMESTAMP — NOT NULL
  • update_at — TIMESTAMP — NOT NULL

tbl_notifications

  • notification_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → tbl_user.user_id — NOT NULL
  • type — ENUM('NEW_MEMBER_REQUEST', 'COMMENT_REPLY', 'TASK_REMINDER', 'SYSTEM') — NOT NULL
  • message — TEXT — NOT NULL
  • url — VARCHAR(255) — NOT NULL
  • is_read — TINYINT(1) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

tbl_position

  • position_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL

tbl_profile

  • profile_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → tbl_user.user_id — NOT NULL
  • desc — TEXT — NOT NULL
  • profile_url — VARCHAR(255) — NOT NULL

tbl_profile_file

  • file_id — BIGINT — Foreign key → tbl_file.file_id — NOT NULL
  • profile_id — BIGINT — Foreign key → tbl_profile.profile_id — NOT NULL

tbl_profile_position

  • position_id — BIGINT — Foreign key → tbl_position.position_id — NOT NULL
  • profile_id — BIGINT — Foreign key → tbl_profile.profile_id — NOT NULL

tbl_profile_stack

  • stack_id — BIGINT — Foreign key → tbl_stack.stack_id — NOT NULL
  • profile_id — BIGINT — Foreign key → tbl_profile.profile_id — NOT NULL

tbl_reply

  • reply_id — BIGINT — Primary key — NOT NULL
  • board_id — BIGINT — Foreign key → tbl_board.board_id — NOT NULL
  • user_id — BIGINT — Foreign key → tbl_user.user_id — NOT NULL
  • desc — TEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

tbl_stack

  • stack_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • desc — VARCHAR(255) — NOT NULL
  • described — TEXT — NOT NULL
  • assort — VARCHAR(255) — NOT NULL

tbl_study

  • study_id — BIGINT — Primary key — NOT NULL
  • leader_id — BIGINT — Foreign key → tbl_user.user_id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • desc — TEXT — NOT NULL
  • is_online — TINYINT(1) — NOT NULL
  • type — ENUM('STUDY', 'PROJECT') — NOT NULL
  • is_opened — TINYINT(1) — NOT NULL
  • min_cap — TINYINT(1) — NOT NULL
  • max_cap — TINYINT(1) — NOT NULL
  • start_at — TIMESTAMP — NOT NULL
  • end_at — TIMESTAMP — NOT NULL
  • location_id — BIGINT — Foreign key → tbl_location.location_id
  • views — INT — NOT NULL

tbl_study_like

  • study_id — BIGINT — Foreign key → tbl_study.study_id — NOT NULL
  • user_id — BIGINT — Foreign key → tbl_user.user_id — NOT NULL

tbl_study_position

  • position_id — BIGINT — Foreign key → tbl_position.position_id — NOT NULL
  • study_id — BIGINT — Foreign key → tbl_study.study_id — NOT NULL

tbl_study_stack

  • stack_id — BIGINT — Foreign key → tbl_stack.stack_id — NOT NULL
  • study_id — BIGINT — Foreign key → tbl_study.study_id — NOT NULL

tbl_submission

  • submission_id — BIGINT — Primary key — NOT NULL
  • task_id — BIGINT — Foreign key → tbl_task.task_id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • views — INT — NOT NULL
  • desc — TEXT — NOT NULL
  • title — VARCHAR(255) — NOT NULL

tbl_submission_file

  • submission_id — BIGINT — Foreign key → tbl_submission.submission_id — NOT NULL
  • file_id — BIGINT — Foreign key → tbl_file.file_id — NOT NULL

tbl_task

  • task_id — BIGINT — Primary key — NOT NULL
  • study_id — BIGINT — Foreign key → tbl_study.study_id — NOT NULL
  • user_id — BIGINT — Foreign key → tbl_user.user_id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • desc — TEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • type — ENUM('ASSIGNMENT', 'PROJECT', 'ETC') — NOT NULL
  • status — ENUM('NOT_STARTED', 'IN_PROGRESS', 'COMPLETED') — NOT NULL
  • start_at — TIMESTAMP
  • end_at — TIMESTAMP

tbl_user

  • user_id — BIGINT — Primary key — NOT NULL
  • nickname — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • login_type — ENUM('EMAIL', 'KAKAO', 'NAVER') — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • status — ENUM('ACTIVE', 'INACTIVE', 'BLOCKED') — NOT NULL
  • role — ENUM('ROLE_USER', 'ROLE_ADMIN') — NOT NULL
  • password — VARCHAR(255) — NOT NULL