UMC실습

테이블 (13)

alarm

  • alarm_id — bigint — 기본 키 — NOT NULL
  • user_ID — bigint — 외래 키 → user.user_ID — NOT NULL
  • is_confirmd (is_confirmed) — boolean — NOT NULL
  • uploaded_at (upladed_at) — datetime — NOT NULL
  • created_at — datetime — NOT NULL

food

  • food_id — bigint — 기본 키 — NOT NULL
  • name — varchar(15) — NOT NULL
  • created_at — datetime — NOT NULL
  • uploaded_at (upladed_at) — datetime — NOT NULL

marketing (marketing_alarm)

  • alarm_id — bigint — 기본 키 — NOT NULL
  • alarm_id (alarm_id2) — bigint — 외래 키 → alarm.alarm_id — NOT NULL
  • title — varchar(30) — NOT NULL
  • body — text — NOT NULL
  • uploaded_at (upladed_at) — datetime — NOT NULL
  • created_at — datetime — NOT NULL

member_agree

  • ma_id — bigint — 기본 키 — NOT NULL
  • user_ID — bigint — 외래 키 → user.user_ID — NOT NULL
  • terms_id — bigint — 외래 키 → terms.terms_id — NOT NULL
  • uploaded_at (upladed_at) — datetime — NOT NULL
  • created_at — datetime — NOT NULL

mission

  • mission_id — bigint — 기본 키 — NOT NULL
  • store_id — bigint — 외래 키 → store.store_id — NOT NULL
  • rate — float — NOT NULL
  • reward — int — NOT NULL
  • body — text — NOT NULL
  • created_at — datetime — NOT NULL
  • uploaded_at (upladed_at) — datetime — NOT NULL
  • status — varchar(15) — NOT NULL
  • deadline — datetime — NOT NULL

notice (notice_alarm)

  • alarm_id — bigint — 기본 키 — NOT NULL
  • alarm_id (alarm_id2) — bigint — 외래 키 → alarm.alarm_id — NOT NULL
  • title — varchar(30) — NOT NULL
  • body — text — NOT NULL
  • uploaded_at (upladed_at) — datetime — NOT NULL
  • created_at — datetime — NOT NULL

preference_food

  • pf_id — bigint — 기본 키 — NOT NULL
  • user_ID — bigint — 외래 키 → user.user_ID — NOT NULL
  • food_id — bigint — 외래 키 → food.food_id — NOT NULL
  • name — varchar(15) — NOT NULL
  • created_at — datetime — NOT NULL
  • uploaded_at (upladed_at) — datetime — NOT NULL

region

  • region_id — bigint — 기본 키 — NOT NULL
  • name — varchar(20) — NOT NULL
  • created_at — datetime — NOT NULL
  • uploaded_at (upladed_at) — datetime — NOT NULL

review

  • reivew_id (revies_id) — bigint — 기본 키 — NOT NULL
  • user_ID — biging — 외래 키 → user.user_ID — NOT NULL
  • store_id — biging — 외래 키 → store.store_id — NOT NULL
  • rate — float — NOT NULL
  • body — text — NOT NULL
  • created_at — datetime — NOT NULL
  • uploaded_at (upladed_at) — datetime — NOT NULL
  • inactive_date — datetime — NOT NULL

store

  • store_id — bigint — 기본 키 — NOT NULL
  • region_id — bigint — 외래 키 → region.region_id — NOT NULL
  • name — varchar(50) — NOT NULL
  • rate — float — NOT NULL
  • created_at — datetime — NOT NULL
  • uploaded_at (upladed_at) — datetime — NOT NULL
  • inactive_date — datetime — NOT NULL
  • status — varchar(15) — NOT NULL
  • time — datetime — NOT NULL
  • address — varchar(50) — NOT NULL

terms

  • terms_id — bigint — 기본 키 — NOT NULL
  • title — bigint — NOT NULL
  • body — text — NOT NULL
  • optional — boolean — NOT NULL
  • uploaded_at (upladed_at) — datetime — NOT NULL
  • created_at — datetime — NOT NULL

user

  • user_ID — bigint — 기본 키 — NOT NULL
  • region_id — bigint — 외래 키 → region.region_id — NOT NULL
  • social_login — varchar(15) — NOT NULL
  • name — varchar(20) — NOT NULL
  • sex — varchar(15) — NOT NULL
  • birth — varchar(15) — NOT NULL
  • address — text — NOT NULL
  • passward — text — NOT NULL
  • created_at — datetime — NOT NULL
  • uploaded_at (upladed_at) — datetime — NOT NULL
  • status — varchar(15) — NOT NULL
  • inactive_date — datetime — NOT NULL
  • point — int — NOT NULL
  • email — varchar(50) — NOT NULL
  • phone — varchar(50)

user_mission

  • user_mission_id — bigint — 기본 키 — NOT NULL
  • user_ID — bigint — 외래 키 → user.user_ID — NOT NULL
  • mission_id (mission_id2) — bigint — 외래 키 → mission.mission_id — NOT NULL
  • status — varchar(15) — NOT NULL
  • created_at — datetime — NOT NULL
  • uploaded_at (upladed_at) — datetime — NOT NULL