umc-study

Tables (5)

food (Untitled2)

  • food_id (id) — Primary key — NOT NULL
  • name (음식이름) — varchar(20)

mem_mission (Untitled5)

  • mamber_id (id) — bigint — Foreign key → member.mamber_id — NOT NULL
  • mission_id (Key) — bigint — Foreign key → mission.mission_id — NOT NULL

member (Untitled)

  • mamber_id (id) — bigint — Primary key — NOT NULL
  • name (이름) — varchar(20) — NOT NULL
  • gender (성별) — bit — NOT NULL
  • address (주소) — text — NOT NULL
  • create_at (설정시간) — datetime(6) — NOT NULL
  • update_at (수정시간) — datetime(6) — NOT NULL
  • status (상태) — varchar(15) — NOT NULL
  • inactive_date (비활성화 시간) — datetime
  • reward (리워드 포인트) — bigint

member_food (Untitled3)

  • mem_food_id (id3) — bigint — Primary key — NOT NULL
  • member_id (id) — bigint — Foreign key → member.mamber_id — NOT NULL
  • food_id (id2) — Foreign key → food.food_id — NOT NULL
  • Field

mission (Untitled4)

  • mission_id (Key) — bigint — Primary key — NOT NULL
  • name (이름) — varchar(10) — NOT NULL
  • region (미션지역) — varchar(20) — NOT NULL