KOA-ERD
Tables (15)
Curriculum (커리큘럼)
- curriculum_id — BIGINT — Primary key — NOT NULL
- notice_id — BIGINT — Foreign key → Notice.notice_id — NOT NULL
- curriculum (커리큘럼) — VARCHAR
- credate (등록일) — DATETIME
- upddate (수정일) — DATETIME
Enroll (팀멤버)
- crew_id — BIGINT — Primary key — NOT NULL
- team_id — BIGINT — Foreign key → team.team_id — NOT NULL
- member_id — BIGINT — Foreign key → Member.member_id — NOT NULL — PK
Member (회원)
- member_id — BIGINT — Primary key — NOT NULL — PK
- 이름 (name) — VARCHAR — NOT NULL — 필수정보
- 이메일 (email) — VARCHAR — NOT NULL — 필수정보
- 프로필 사진 (picture) — VARCHAR — 선택정보
- 아이디 (id) — VARCHAR
- 비밀번호 (password) — VARCHAR
- 등록일 (credate) — DATETIME — NOT NULL
- 수정일 (upddate) — DATETIME — NOT NULL
MemberInfo (회원추가정보)
- member_id — BIGINT — Foreign key → Member.member_id — NOT NULL — PK
- 전공 (major) — VARCHAR
- 파트 (part) — VARCHAR
- 전화번호 (phone) — VARCHAR
- 소개 (description) — VARCHAR
- 등록일 (credate) — DATETIME
- 수정일 (upddate) — DATETIME — NOT NULL
Notice (공지)
- notice_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → Member.member_id — NOT NULL — PK
- title (제목) — VARCHAR
- content (내용) — VARCHAR
- credate (등록일) — DATETIME
- upddate (수정일) — DATETIME
NoticeImage (공지 이미지)
- Key — Primary key — NOT NULL
- notice_id — BIGINT — Foreign key → Notice.notice_id — NOT NULL
- imgUrl (이미지 Url)
- credate (등록일)
- upddate (수정일)
NoticeReport (신고)
- report_id — BIGINT — Primary key — NOT NULL
- reply_id — BIGINT — Foreign key → Reply.reply_id — NOT NULL
- content (신고 사유 제목) — VARCHAR
NoticeView (조회수)
- view_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → Member.member_id — NOT NULL — PK
- view (조회수) — INTEGER
- notice_id — BIGINT — Foreign key → Notice.notice_id — NOT NULL
Reply (댓글)
- reply_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → Member.member_id — NOT NULL — PK
- reply_id (reply 자기참조) — BIGINT — Foreign key → Reply.reply_id — NOT NULL
- notice_id — BIGINT — Foreign key → Notice.notice_id — NOT NULL
- content (내용) — VARCHAR
- credate (등록일) — DATETIME
- upddate (수정일) — DATETIME
Team (주최 팀)
- Key — Primary key — NOT NULL
- name (팀 이름)
- credate (등록일)
- upddate (수정일)
- notice_id — BIGINT — Foreign key → Notice.notice_id — NOT NULL
Vote (투표)
- vote_id — BIGINT — Primary key — NOT NULL
- notice_id — BIGINT — Foreign key → Notice.notice_id — NOT NULL
- title (투표 제목)
- credate (등록일) — DATETIME
- upddate (수정일) — DATETIME
VoteItem (투표항목)
- detail_id — BIGINT — Primary key — NOT NULL
- vote_id — BIGINT — Foreign key → Vote.vote_id — NOT NULL
- name (항목이름) — VARCHAR
VoteItemRecord (투표항목기록)
- record_id — Primary key — NOT NULL
- detail_id — BIGINT — Foreign key → VoteItem.detail_id — NOT NULL
- member_id — BIGINT — Foreign key → Member.member_id — NOT NULL — PK
attend (출석)
- attend_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → Member.member_id — NOT NULL — PK
- curriculum_id — BIGINT — Foreign key → Curriculum.curriculum_id — NOT NULL
- status (출석 상태)
- credate (등록일) — DATETIME
- upddate (수정일) — DATETIME
team (커리큘럼 내 팀)
- team_id — BIGINT — Primary key — NOT NULL
- curriculum_id (category_id) — BIGINT — Foreign key → Curriculum.curriculum_id — NOT NULL
- title (팀명) — VARCHAR