점메추저메추
테이블 (17)
Board_Like (게시글좋아요)
- user_id (id) — int
- board_id — int
Board_img (보드이미지)
- board_img_id — int — 기본 키 — NOT NULL
- user_id (id2) — int
- created_at — timestamp
- deleted_at — datetime
- updated_at — timestamp
Category (카테고리)
- category_id (Key) — int — 기본 키 — NOT NULL
- name_top — boolean
- top_category_id (Field2) — int
- down_category_name (Field) — varchar
- created_at — timestamp
- updated_at — timestamp
Comment (댓글)
- comment_id — int — 기본 키 — NOT NULL
- feed_id — int — 외래 키 → Feed.feed_id — NOT NULL
- user_id — int — 외래 키 → User.user_id — NOT NULL
- comment — varchar(300)
- created_at — timestamp
- updated_at — timestamp
- deleted_at — datetime
Favorate (찜하기)
- favorate_id — int — 기본 키 — NOT NULL
- user_id — int — 외래 키 → User.user_id — NOT NULL
- store_name — varchar
- store_address — varchar
- store_business_hours — int
- store_contact — int
- store_keyword — varchar
- store_img (Field) — varchar
Feed (피드)
- feed_id — int — 기본 키 — NOT NULL
- basket_id — int — 외래 키 → Favorate.favorate_id — NOT NULL
- user_id (id2) — int — 외래 키 → User.user_id — NOT NULL
- title — varchar(300)
- description — varchar(300)
- created_at — timestamp
- updated_at — timestamp
- deleted_at — datetime
Feed_like (피드 좋아요)
- user_id — int — 외래 키 → User.user_id — NOT NULL
- feed_id — int — 외래 키 → Feed.feed_id — NOT NULL
Food_Like (음식좋아요)
- food_like_id — int — 기본 키 — NOT NULL
- created_at — timestamp
- updated_at — timestamp
Friend (친구)
- friend_id (친구id) — int — 기본 키 — NOT NULL
- friend_name (친구이름) — varchar(64)
- Field2
- Field3
Menu (메뉴)
- menu_id — int — 기본 키 — NOT NULL
- category_id (Key) — int — 외래 키 → Category.category_id — NOT NULL
- name — int
- ingrediant — varchar
- created_at — datetime
- updated_at — timestamp
Menu_img (메뉴 이미지)
- menu_img_id — int — 기본 키 — NOT NULL
- menu_id — int — 외래 키 → Menu.menu_id — NOT NULL
- category_id (Key) — int — 외래 키 → Menu.category_id — NOT NULL
- created_at — datetime
- updated_at — timestamp
Menu_like (메뉴선호도정보)
- user_id — int — 외래 키 → User.user_id — NOT NULL
- menu_id — int — 외래 키 → Menu.menu_id — NOT NULL
- preference (선호도) — int
Note (쪽지)
- note_id (채팅id) — int — 기본 키 — NOT NULL
- note_message (채팅메시지)
- Field2
Store (추천상점)
- store_id — int — 기본 키 — NOT NULL
- name — varchar(128)
- is_selected (Field) — int
- created_at — timestamp
- updated_at — timestamp
User (회원정보)
- user_id (id) — int — 기본 키 — NOT NULL
- email — varchar(64)
- is_admin — boolean
- nick_name — varchar(16)
- password — varchar(300)
- refresh_token — varchar(300)
- created_at — timestamp
- updated_at — timestamp
- deleted_at — datetime
advertisement (광고)
- Key — 기본 키 — NOT NULL
- Field
- Field2