도서 대여 관리

테이블 (5)

Mission (user)

  • mission_id (Key) — 기본 키 — NOT NULL
  • store_id (Key2) — NOT NULL
  • title (Key3) — NOT NULL
  • content (Key4) — NOT NULL
  • point (Key5) — NOT NULL
  • mission_type (Key6) — NOT NULL
  • is_active (Key7) — NOT NULL

Region (user)

  • region_id (Key) — 기본 키 — NOT NULL
  • name (Key2) — NOT NULL
  • description (Key3) — NOT NULL

Store (user)

  • stroe_id (Key) — 기본 키 — NOT NULL
  • region_id (Key2) — NOT NULL
  • name (Key3) — NOT NULL
  • address (Key4) — NOT NULL
  • description (Key5) — NOT NULL

User (user)

  • user_id — 기본 키 — NOT NULL
  • email — NOT NULL
  • status (Key6) — NOT NULL
  • created_at (Key5) — NOT NULL
  • nickname (Key4) — NOT NULL
  • password — NOT NULL

UserMission (user)

  • user_mission_id (Key) — 기본 키 — NOT NULL
  • mission_id (Key3) — NOT NULL
  • status (Key4) — NOT NULL
  • completed_at (Key5) — NOT NULL
  • Field