UMC미션_10.11

테이블 (12)

alarm

  • alarm_id (id) — bigint — 기본 키 — NOT NULL
  • 회원id (id2) — bigint — 외래 키 → user.회원id — NOT NULL
  • is_confiremd — boolean — NOT NULL
  • created_at — datetime — NOT NULL
  • uploaded_at — datetime — NOT NULL

food

  • 음식id (id) — bigint — 기본 키 — NOT NULL
  • 이름 (name) — varchar(15) — NOT NULL
  • created_at — datetime — NOT NULL
  • uploaded_at — datetime — NOT NULL

marketing (marketing_notice)

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

mission

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

my_page (CopyOfUntitled2)

  • my_page_id (id) — bigint — 기본 키 — NOT NULL
  • 회원id (id2) — bigint(20) — 외래 키 → user.회원id — NOT NULL
  • help — bigint — 외래 키 → 약관.my_page_id — NOT NULL
  • piont (point) — int — NOT NULL
  • created_at — datetime — NOT NULL
  • uploaded_at — datetime — NOT NULL
  • status — varchar(15) — NOT NULL
  • inactive_date — datetime

notice (notice_alarm)

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

preference_food (preferce_food)

  • 음식id (id) — bigint — 기본 키 — NOT NULL
  • 회원id (id2) — bigint(20) — 외래 키 → user.회원id — NOT NULL
  • 음식id (id3) — bigint(20) — 외래 키 → food.음식id — NOT NULL
  • 이름 (name) — varchar(15) — NOT NULL
  • created_at — datetime — NOT NULL
  • uploaded_at — datetime — NOT NULL

review

  • 회원id (id) — bigint — 기본 키 — NOT NULL
  • 회원id (id2) — bigint — 외래 키 → user.회원id — NOT NULL
  • store_id — bigint — 외래 키 → store.store_id — NOT NULL
  • body — varchar(15)
  • created_at — datetime — NOT NULL
  • uploaded_at — datetime — NOT NULL
  • inactive_date — datetime — NOT NULL
  • rate — NOT NULL
  • status (stauts) — varchar(15) — NOT NULL

store

  • store_id — bigint — 기본 키 — NOT NULL
  • rate — int — NOT NULL
  • place — varchar(30) — NOT NULL
  • created_at — datetime — NOT NULL
  • uploaded_at — datetime — NOT NULL
  • status — varchar(15) — NOT NULL
  • inactive_date — datetime — NOT NULL
  • time — datetime — NOT NULL

user

  • 회원id (id) — bigint — 기본 키 — NOT NULL
  • social_login — varchar(15) — NOT NULL
  • 이름 (name) — varchar(15) — NOT NULL
  • 성별 (sex) — varchar(15) — NOT NULL
  • 생년월일 (birth) — varchar(15) — NOT NULL
  • 주소 (address) — varchar(15) — NOT NULL
  • password — varchar(30) — NOT NULL
  • created_at — datetime — NOT NULL
  • uploaded_at — datetime — NOT NULL
  • status — varchar(15) — NOT NULL
  • inactive_date — datetime — NOT NULL

user_mission (user_miisioon)

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

약관

  • my_page_id (id) — bigint — 기본 키 — NOT NULL
  • body — text
  • created_at — datetime — NOT NULL
  • uploaded_at — datetime — NOT NULL
  • inactive_date — datetime