해커톤 i팀

테이블 (7)

CalendarMission (캘린더-미션)

  • id (Key) — Long — 기본 키 — NOT NULL
  • calender_id (Key2) — Long — 외래 키 → Calender.id — NOT NULL
  • date (Field) — DATETIME
  • content (Field6)
  • is_complete (Field2) — Boolean — NOT NULL
  • created_at (Field3) — DATETIME — NOT NULL
  • updated_at (Field4) — DATETIME
  • deleted_at (Field5) — DATETIME

CalendarVisitor (방명록)

  • id (Key3) — 기본 키 — NOT NULL
  • owner_id (Key2) — Long — 외래 키 → Member.id — NOT NULL
  • content (Field) — String
  • writerId (Key) — Long — 외래 키 → Member.id — NOT NULL
  • isChecked (Field2) — boolean

Calender (캘린더)

  • id (Key) — Long — 기본 키 — NOT NULL
  • member_id (Key2) — Long — 외래 키 → Member.id — NOT NULL
  • is_completed (Boolean) — Boolean
  • created_at (Field) — DATETIME — NOT NULL
  • updated_at (Field2) — DATETIME
  • deleted_at (Field3) — DATETIME

Friend (친구)

  • id (Key) — Long — 기본 키 — NOT NULL
  • member1_id (Key2) — Long — 외래 키 → Member.id — NOT NULL
  • member2_id (Key3) — Long — 외래 키 → Member.id — NOT NULL

Member (멤버)

  • id (Key) — Long — 기본 키 — NOT NULL
  • login_id (Field7) — String
  • nickname (Field) — String — NOT NULL
  • password (Field2) — String — NOT NULL
  • refreshToken (Field6) — String
  • created_at (Field3) — DATETIME — NOT NULL
  • updated_at (Field4) — DATETIME
  • deleted_at (Field5) — DATETIME

MemberReward (멤버-리워드)

  • id (Key) — Long — 기본 키 — NOT NULL
  • member_id (Key2) — Long — 외래 키 → Member.id — NOT NULL
  • reward_id (Key3) — 외래 키 → Reward.id — NOT NULL

Reward (상)

  • id (Key) — 기본 키 — NOT NULL
  • content (Field2) — String