week1

Tables (6)

Mission (미션)

  • mission_id (Key) — VARCHAR(10) — Primary key — NOT NULL
  • title (Field) — VARCHAR(50)
  • is_completed (Field2) — int
  • user_id (Key2) — VARCHAR(10) — Foreign key → user.user_id — NOT NULL
  • onboarding_id (Key22) — Foreign key → user.onboarding_id — NOT NULL
  • Field3

onboarding (온보딩)

  • onboarding_id (Key) — Primary key — NOT NULL
  • Field

point (포인트)

  • user_id (Key) — VARCHAR(10) — Foreign key → user.user_id — NOT NULL
  • onboarding_id (Key2) — Foreign key → user.onboarding_id — NOT NULL

review (리뷰)

  • Key — VARCHAR(10) — Primary key — NOT NULL
  • mission_id (Key2) — VARCHAR(10) — Foreign key → Mission.mission_id — NOT NULL
  • Field
  • Field2

store (가게)

  • store_id (Key) — Primary key — NOT NULL
  • user_id (Key2) — VARCHAR(10) — Foreign key → user.user_id — NOT NULL
  • onboarding_id (Key22) — Foreign key → user.onboarding_id — NOT NULL

user (사용자)

  • user_id (Key) — VARCHAR(10) — Primary key — NOT NULL
  • onboarding_id (Key2) — Foreign key → onboarding.onboarding_id — NOT NULL
  • username (Field) — VARCHAR(20)
  • password (Field2) — VARCHAR(20)
  • Field3 — VARCHAR(50)