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