database_practice

Tables (16)

BOARD_COMMENT

  • comment_id — bigint — Primary key — NOT NULL
  • board_id — bigint — Foreign key → PROJECT_BOARD.board_id — NOT NULL
  • writer_id — bigint — Foreign key → MEMBER.member_id — NOT NULL
  • content — varchar(1000) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime
  • parent_id — bigint — Foreign key → BOARD_COMMENT.comment_id

INTEREST_FIELD

  • field_id — bigint — Primary key — NOT NULL
  • field_name — varchar(50) — NOT NULL
  • description — varchar(255)

MAJOR

  • major_id — bigint — Primary key — NOT NULL
  • major_name — varchar(100) — NOT NULL
  • college_name — varchar(100)
  • use_yn — char(1) — NOT NULL

MEMBER

  • member_id — bigint — Primary key — NOT NULL
  • student_no — varchar(20) — NOT NULL
  • name — varchar(50) — NOT NULL
  • phone — varchar(20) — NOT NULL
  • email — varchar(100) — NOT NULL
  • password_hash — varchar(255) — NOT NULL
  • member_status — varchar(20) — NOT NULL
  • join_date — datetime — NOT NULL
  • member_role — varchar(20) — NOT NULL
  • grade — tinyint
  • major_id — bigint — Foreign key → MAJOR.major_id
  • intro — varchar(400)

MEMBER_INTEREST

  • member_interest_id — bigint — Primary key — NOT NULL
  • member_id — bigint — Foreign key → MEMBER.member_id — NOT NULL
  • field_id — bigint — Foreign key → INTEREST_FIELD.field_id — NOT NULL
  • priority_rank — tinyint

MEMBER_SKILL

  • member_skill_id — bigint — Primary key — NOT NULL
  • member_id — bigint — Foreign key → MEMBER.member_id — NOT NULL
  • skill_id — bigint — Foreign key → SKILL.skill_id — NOT NULL
  • level — varchar(20)
  • experience_yr — tinyint

PROJECT

  • project_id — bigint — Primary key — NOT NULL
  • leader_id — bigint — Foreign key → MEMBER.member_id — NOT NULL
  • field_id — bigint — Foreign key → INTEREST_FIELD.field_id — NOT NULL
  • title — varchar(100) — NOT NULL
  • summary — varchar(255)
  • description — text
  • recruit_total — int — NOT NULL
  • current_member — int — NOT NULL
  • recruit_status — varchar(20) — NOT NULL
  • meeting_type — varchar(20) — NOT NULL
  • start_date — date
  • end_date — date
  • apply_deadline — date — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime

PROJECT_APPLY

  • apply_id — bigint — Primary key — NOT NULL
  • project_id — bigint — Foreign key → PROJECT.project_id — NOT NULL
  • member_id — bigint — Foreign key → MEMBER.member_id — NOT NULL
  • apply_role — varchar(50) — NOT NULL
  • motivation — varchar(400)
  • portfolio_link — varchar(255)
  • apply_status — varchar(20) — NOT NULL
  • applied_at — datetime — NOT NULL
  • decided_at — datetime

PROJECT_BOARD

  • board_id — bigint — Primary key — NOT NULL
  • project_id — bigint — Foreign key → PROJECT.project_id — NOT NULL
  • writer_id — bigint — Foreign key → MEMBER.member_id — NOT NULL
  • title — varchar(200) — NOT NULL
  • content — text — NOT NULL
  • board_type — varchar(20) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime

PROJECT_BOOKMARK

  • bookmark_id — bigint — Primary key — NOT NULL
  • member_id — bigint — Foreign key → MEMBER.member_id — NOT NULL
  • project_id — bigint — Foreign key → PROJECT.project_id — NOT NULL
  • bookmarked_at — datetime — NOT NULL

PROJECT_MEETING

  • meeting_id — bigint — Primary key — NOT NULL
  • project_id — bigint — Foreign key → PROJECT.project_id — NOT NULL
  • title — varchar(100) — NOT NULL
  • meeting_date — date — NOT NULL
  • start_time — varchar(8) — NOT NULL
  • end_time — varchar(8) — NOT NULL
  • location — varchar(200)
  • online_link — varchar(255)
  • memo — varchar(1000)

PROJECT_MEMBER

  • proj_member_id — bigint — Primary key — NOT NULL
  • project_id — bigint — Foreign key → PROJECT.project_id — NOT NULL
  • member_id — bigint — Foreign key → MEMBER.member_id — NOT NULL
  • role_name — varchar(50) — NOT NULL
  • joined_at — datetime — NOT NULL
  • leave_at — datetime
  • member_status — varchar(20) — NOT NULL
  • is_leader — char(1) — NOT NULL

PROJECT_SKILL

  • project_skill_id — bigint — Primary key — NOT NULL
  • project_id — bigint — Foreign key → PROJECT.project_id — NOT NULL
  • skill_id — bigint — Foreign key → SKILL.skill_id — NOT NULL
  • need_level — varchar(20)
  • is_required — char(1) — NOT NULL

PROJECT_TASK

  • task_id — bigint — Primary key — NOT NULL
  • project_id — bigint — Foreign key → PROJECT.project_id — NOT NULL
  • title — varchar(200) — NOT NULL
  • description — varchar(1000)
  • status — varchar(20) — NOT NULL
  • priority — varchar(10) — NOT NULL
  • due_date — date
  • created_by — bigint — Foreign key → MEMBER.member_id — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime

SKILL

  • skill_id — bigint — Primary key — NOT NULL
  • skill_name — varchar(50) — NOT NULL
  • category — varchar(30) — NOT NULL

TASK_ASSIGN

  • task_assign_id — bigint — Primary key — NOT NULL
  • task_id — bigint — Foreign key → PROJECT_TASK.task_id — NOT NULL
  • member_id — bigint — Foreign key → MEMBER.member_id — NOT NULL
  • assigned_at — datetime — NOT NULL