cafe_project_수정
테이블 (10)
bookmark
- id — BIGINT
- user_id — BIGINT — NOT NULL
- cafe_id — BIGINT — NOT NULL
- created_at — DATETIME — NOT NULL
cafe
- cafe_id — BIGINT
- cafe_name — VARCHAR(100) — NOT NULL
- phone_num — VARCHAR(30)
- site_url — VARCHAR(255)
- address1 — VARCHAR(120)
- address2 — VARCHAR(120)
- district — VARCHAR(60)
- city — VARCHAR(60)
- lat — DECIMAL(10,7)
- lng — DECIMAL(10,7)
- open_time — TIME
- close_time — TIME
- parking_yn — TINYINT(1) — NOT NULL
- hit_count — INT — NOT NULL
- like_count — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- FULLTEXT — KEY
cafe_image
- cafe_id — BIGINT — 기본 키 — NOT NULL
- is_primary — TINYINT(1) — 기본 키 — NOT NULL
- sort_order — INT — 기본 키 — NOT NULL
- id — BIGINT
- img_url — VARCHAR(255) — NOT NULL
- created_at — DATETIME — NOT NULL
cafe_keyword
- id — BIGINT
- cafe_id — BIGINT — NOT NULL
- keyword_id — BIGINT — NOT NULL
cafe_menu
- id — BIGINT
- cafe_id — BIGINT — NOT NULL
- menu_id — BIGINT — NOT NULL
- price — INT
- is_visible — TINYINT(1) — NOT NULL
keyword
- id — BIGINT
- name — VARCHAR(50) — NOT NULL
- type_id — BIGINT — NOT NULL
keyword_type
- id — BIGINT
- type_name — VARCHAR(50) — NOT NULL
menu
- id — BIGINT
- menu_name — VARCHAR(80) — NOT NULL
- base_price — INT
review
- id — BIGINT
- cafe_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- rating — TINYINT — NOT NULL
- content — TEXT
- like_count — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
user
- user_id — BIGINT
- email — VARCHAR(120) — NOT NULL
- nickname — VARCHAR(40) — NOT NULL
- password_hash — VARCHAR(200) — NOT NULL
- created_at — DATETIME — NOT NULL