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