Spring

Tables (4)

Member

  • 기본키 (MEMBER_ID) — VARCHAR(20) — Primary key
  • Field (Name) — VARCHAR(20)
  • Field2 (Gender) — ENUM('남','여')
  • Field3 (BIRTH) — DATE
  • Field4 (ADDRESS) — VARCHAR(100)

Untitled (FOOD_PREFERENCES)

  • Key (FOOD_ID) — VARHCAR(30) — Primary key — NOT NULL
  • Field (FOOD_NAME) — VARCHAR(30)

Untitled (MEMBER_FOOD)

  • 기본키 (MEMBER_ID) — VARCHAR(20) — Foreign key → Member.기본키
  • Key (FOOD_ID) — VARHCAR(30) — Foreign key → Untitled.Key — NOT NULL

Untitled (MISSION)

  • Key — Primary key — NOT NULL
  • Field
  • Field2
  • Field3