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