UMC-1

테이블 (15)

Alarms

  • alarm_id — NOT NULL — 기본 키 — NOT NULL
  • user_id — NOT NULL — 외래 키 → Users.user_id — NOT NULL
  • alarm_name — NOT NULL — NOT NULL
  • status — NOT NULL — NOT NULL
  • created_at — NOT NULL — NOT NULL
  • updated_at — NOT NULL — NOT NULL

Book_Hashtags

  • bh_id — NOT NULL — 기본 키 — NOT NULL
  • book_id — NOT NULL — 외래 키 → Books.book_id — NOT NULL
  • hashtag_id — NOT NULL — 외래 키 → Hashtags.hashtag_id — NOT NULL
  • created_at — NOT NULL — NOT NULL
  • updated_at — NOT NULL — NOT NULL

Book_Likes

  • like_id — NOT NULL — 기본 키 — NOT NULL
  • user_id — NOT NULL — 외래 키 → Users.user_id — NOT NULL
  • book_id — NOT NULL — 외래 키 → Books.book_id — NOT NULL
  • created_at — NOT NULL — NOT NULL
  • updated_at — NOT NULL — NOT NULL

Books

  • book_id — NOT NULL — 기본 키 — NOT NULL
  • category_id — NOT NULL — 외래 키 → Category.category_id — NOT NULL
  • book_name — NOT NULL — NOT NULL
  • description — NULL
  • created_at — NOT NULL — NOT NULL
  • updated_at — NOT NULL — NOT NULL

Category

  • category_id — NOT NULL — 기본 키 — NOT NULL
  • category_name — NOT NULL — NOT NULL
  • book_count — NOT NULL — NOT NULL
  • created_at — NOT NULL — NOT NULL
  • updated_at — NOT NULL — NOT NULL

Hashtags

  • hashtag_id — NOT NULL — 기본 키 — NOT NULL
  • hashtag_name — NOT NULL — NOT NULL
  • created_at — NOT NULL — NOT NULL
  • updated_at — NOT NULL — NOT NULL

Users

  • user_id — NOT NULL — 기본 키 — NOT NULL
  • user_name — NOT NULL — NOT NULL
  • user_nickname — NOT NULL — NOT NULL
  • user_phone — NULL
  • user_gender — NOT NULL — NOT NULL
  • created_at — NOT NULL — NOT NULL
  • updated_at — NOT NULL — NOT NULL

alarms

  • id — NOT NULL — 기본 키 — NOT NULL
  • user_id — NOT NULL — 외래 키 → users.id — NOT NULL
  • name — NOT NULL — NOT NULL
  • created_at — NOT NULL — NOT NULL
  • updated_at — NOT NULL — NOT NULL
  • status — NOT NULL — NOT NULL
  • onoff — NOT NULL

missions

  • id — NOT NULL — 기본 키 — NOT NULL
  • shop_id — NOT NULL — 외래 키 → shops.id — NOT NULL
  • user_id — NOT NULL — 외래 키 → users.id — NOT NULL
  • name — NOT NULL — NOT NULL
  • created_at — NOT NULL — NOT NULL
  • updated_at — NOT NULL — NOT NULL
  • status — NULL
  • point — NOT NULL
  • is_success — NOT NULL — NOT NULL

questions

  • id — NOT NULL — 기본 키 — NOT NULL
  • user_id — NOT NULL — 외래 키 → users.id — NOT NULL
  • name — NOT NULL — NOT NULL
  • content — NOT NULL — NOT NULL
  • created_at — NOT NULL — NOT NULL
  • updated_at — NOT NULL — NOT NULL
  • status — NOT NULL — NOT NULL
  • comment — NULL

reviews

  • id — NOT NULL — 기본 키 — NOT NULL
  • user_id — NOT NULL — 외래 키 → users.id — NOT NULL
  • shop_id — NOT NULL — 외래 키 → shops.id — NOT NULL
  • content — NULL — NOT NULL
  • star — NOT NULL — NOT NULL
  • created_at — NOT NULL — NOT NULL
  • updated_at — NOT NULL — NOT NULL
  • comment — NULL

shops

  • id — NOT NULL — 기본 키 — NOT NULL
  • name — NOT NULL — NOT NULL
  • address — NULL
  • num — NOT NULL — NOT NULL
  • created_at — NOT NULL — NOT NULL
  • updated_at — NOT NULL — NOT NULL
  • category — NULL
  • status — NULL

users

  • id — NOT NULL — 기본 키 — NOT NULL
  • name — NOT NULL — NOT NULL
  • gender — NOT NULL — NOT NULL
  • birth — NOT NULL — NOT NULL
  • address — NOT NULL — NOT NULL
  • created_at — NOT NULL — NOT NULL
  • updated_at — NOT NULL — NOT NULL
  • status — NOT NULL — NOT NULL
  • inactive_date — NULL
  • point — NOT NULL — NOT NULL
  • mission_count — NOT NULL

선호 음식 (foods)

  • id — NOT NULL — 기본 키 — NOT NULL
  • name — NOT NULL — NOT NULL
  • book_count — NOT NULL — NOT NULL
  • created_at — NOT NULL — NOT NULL
  • updated_at — NOT NULL — NOT NULL

중계테이블 (users_foods)

  • id — NOT NULL — 기본 키 — NOT NULL
  • food_id — NOT NULL — 외래 키 → 선호 음식.id — NOT NULL
  • user_id — NOT NULL — 외래 키 → users.id — NOT NULL
  • created_at — NOT NULL — NOT NULL
  • updated_at — NOT NULL — NOT NULL