tst
Tables (13)
bookmark
- bookmark_id — BIGINT — Primary key
- cafe_id (cafe_id2) — BIGINT — Foreign key → cafe.cafe_id
- user_id (user_id2) — BIGINT — Foreign key → site_user.user_id
- id (id22) — BIGINT — Foreign key → cafe.id
- user_id (user_id22) — BIGINT — Foreign key → cafe.user_id
- user_id — BIGINT
- cafe_id — BIGINT
business
- id — BIGINT — Primary key
- user_id (user_id2) — BIGINT — Foreign key → site_user.user_id
- user_id — BIGINT
- company_name — VARCHAR(255)
- business_number — VARCHAR(255)
- representative_name — VARCHAR(255)
- representative_email — VARCHAR(255)
- representative_phone — VARCHAR(255)
- address — VARCHAR(255)
- description — VARCHAR(255)
- created_at — DATETIME
- updated_at — DATETIME
cafe
- cafe_id — BIGINT — Primary key
- id (id2) — BIGINT — Foreign key → business.id
- user_id (user_id2) — BIGINT — Foreign key → business.user_id
- cafe_name — VARCHAR(255)
- phone_num — VARCHAR(255)
- site_url — VARCHAR(255)
- address1 — VARCHAR(255)
- address2 — VARCHAR(255)
- district — VARCHAR(255)
- city — VARCHAR(255)
- lat — DECIMAL(19,2)
- lng — DECIMAL(19,2)
- open_time — VARCHAR(255)
- close_time — VARCHAR(255)
- parking_yn — TINYINT(1)
- hit_count — INT
- intro — VARCHAR(255)
- user_id — BIGINT
cafe_image
- id — BIGINT — Primary key
- cafe_id (cafe_id2) — BIGINT — Foreign key → cafe.cafe_id
- id (id22) — BIGINT — Foreign key → cafe.id
- user_id (user_id2) — BIGINT — Foreign key → cafe.user_id
- cafe_id — BIGINT
- img_url — VARCHAR(255)
cafe_keyword
- id — BIGINT — Primary key
- cafe_id (cafe_id2) — BIGINT — Foreign key → cafe.cafe_id
- id (id22) — BIGINT — Foreign key → cafe.id
- user_id (user_id2) — BIGINT — Foreign key → cafe.user_id
- cafe_id — BIGINT
- keyword_id — BIGINT
cafe_menu
- menu_id — BIGINT — Primary key
- cafe_id (cafe_id3) — BIGINT — Foreign key → cafe.cafe_id
- id (id22) — BIGINT — Foreign key → cafe.id
- user_id (user_id2) — BIGINT — Foreign key → cafe.user_id
- cafe_id — BIGINT
- name — VARCHAR(255)
- price — INT
- description — VARCHAR(255)
- sort_order — INT
- cafe_id (cafe_id2) — BIGINT
keyword
- id — BIGINT — Primary key
- id (id2) — BIGINT — Foreign key → keyword_type.id
- id (id3) — BIGINT — Foreign key → cafe_keyword.id
- cafe_id (cafe_id2) — BIGINT — Foreign key → cafe_keyword.cafe_id
- id (id22) — BIGINT — Foreign key → cafe_keyword.id
- user_id (user_id2) — BIGINT — Foreign key → cafe_keyword.user_id
- name — VARCHAR(255)
- type_id — BIGINT
- description — VARCHAR(255)
keyword_type
- id — BIGINT — Primary key
- type_name — VARCHAR(255)
likedUsers (Untitled)
- user_id — BIGINT — Foreign key → site_user.user_id
- cafe_id — BIGINT — Foreign key → cafe.cafe_id
- id (id2) — BIGINT — Foreign key → cafe.id
- user_id (user_id2) — BIGINT — Foreign key → cafe.user_id
review_images
- id — BIGINT — Primary key
- id (id2) — BIGINT — Foreign key → reviews.id
- cafe_id (cafe_id2) — BIGINT — Foreign key → reviews.cafe_id
- user_id (user_id2) — BIGINT — Foreign key → reviews.user_id
- id (id22) — BIGINT — Foreign key → reviews.id
- user_id (user_id22) — BIGINT — Foreign key → reviews.user_id
- review_id — BIGINT
- image_url — VARCHAR(255)
review_report
- id — BIGINT — Primary key
- id (id2) — BIGINT — Foreign key → reviews.id
- cafe_id (cafe_id2) — BIGINT — Foreign key → reviews.cafe_id
- user_id — BIGINT — Foreign key → site_user.user_id
- user_id (user_id2) — BIGINT — Foreign key → reviews.user_id
- id (id22) — BIGINT — Foreign key → reviews.id
- user_id (user_id22) — BIGINT — Foreign key → reviews.user_id
- review — BIGINT
- reporter — BIGINT
- reason — VARCHAR(255)
reviews
- id — BIGINT — Primary key
- cafe_id (cafe_id2) — BIGINT — Foreign key → cafe.cafe_id
- user_id (user_id2) — BIGINT — Foreign key → site_user.user_id
- id (id22) — BIGINT — Foreign key → cafe.id
- user_id (user_id22) — BIGINT — Foreign key → cafe.user_id
- cafe_id — BIGINT
- user_id — BIGINT
- rating — DOUBLE
- content — VARCHAR(255)
site_user
- user_id — BIGINT — Primary key
- username — VARCHAR(255)
- password — VARCHAR(255)
- email — VARCHAR(255)
- nickname — VARCHAR(255)
- last_login — DATETIME
- created_at — DATETIME
- updated_at — DATETIME
- reviews — VARCHAR(255)
- bookmarks — VARCHAR(255)
- phone — VARCHAR(255)
- rrn — VARCHAR(255)
- business_user — BIGINT