whats_hot
Tables (16)
_file
- id — bigint(20) — Primary key — NOT NULL
- create_date — datetime(6)
- modify_date — datetime(6)
- domain — enum('MEMBER','SPOT','REVIEW')
- ext — varchar(255)
- name — varchar(255)
- size — bigint(20)
- uuid — varchar(255)
category
- id — bigint(20) — Primary key — NOT NULL
- create_date — datetime(6)
- modify_date — datetime(6)
- depth — int(11)
- name — varchar(255)
- parent_id — bigint(20) — Foreign key → category.id
comment
- id — bigint(20) — Primary key — NOT NULL
- create_date — datetime(6)
- modify_date — datetime(6)
- content — varchar(255)
- liked — bigint(20)
- author_id — bigint(20) — Foreign key → member.id
- review_id — bigint(20) — Foreign key → review.id
- tag_id — bigint(20) — Foreign key → comment.id
comment_liked_member
- liked_member_id — bigint(20) — Foreign key → member.id — NOT NULL
- comment_id — bigint(20) — Foreign key → comment.id — NOT NULL
hashtag
- id — bigint(20) — Primary key — NOT NULL
- create_date — datetime(6)
- modify_date — datetime(6)
- name — varchar(255)
member
- id — bigint(20) — Primary key — NOT NULL
- create_date — datetime(6)
- modify_date — datetime(6)
- email — varchar(255)
- is_logout — bit(1) — NOT NULL
- member_status — enum('ACTIVE','INACTIVE','ARCHIVED','PROHIBITED')
- password — varchar(255)
- username — varchar(255)
member_authorities
- member_id — bigint(20) — Foreign key → member.id — NOT NULL
- authorities — enum('ADMIN','USER')
member_image
- id — bigint(20) — Primary key — NOT NULL
- create_date — datetime(6)
- modify_date — datetime(6)
- image_id — bigint(20) — Foreign key → _file.id
- member_id — bigint(20) — Foreign key → member.id
menu_item
- id — bigint(20) — Primary key — NOT NULL
- create_date — datetime(6)
- modify_date — datetime(6)
- name — varchar(255)
- price — varchar(255)
- spot_id — bigint(20) — Foreign key → spot.id
review
- id — bigint(20) — Primary key — NOT NULL
- create_date — datetime(6)
- modify_date — datetime(6)
- content — varchar(255)
- liked — bigint(20)
- score — double
- status — enum('DRAFT','PUBLIC','PRIVATE')
- title — varchar(255)
- validated — bit(1) — NOT NULL
- visit_date — datetime(6)
- author_id — bigint(20) — Foreign key → member.id
- spot_id — bigint(20) — Foreign key → spot.id
review_hashtag
- id — bigint(20) — Primary key — NOT NULL
- create_date — datetime(6)
- modify_date — datetime(6)
- hashtag_id — bigint(20) — Foreign key → hashtag.id
- review_id — bigint(20) — Foreign key → review.id
review_image
- id — bigint(20) — Primary key — NOT NULL
- create_date — datetime(6)
- modify_date — datetime(6)
- image_id — bigint(20) — Foreign key → _file.id
- review_id — bigint(20) — Foreign key → review.id
review_liked_member
- liked_member_id — bigint(20) — Foreign key → member.id — NOT NULL
- review_id — bigint(20) — Foreign key → review.id — NOT NULL
spot
- id — bigint(20) — Primary key — NOT NULL
- create_date — datetime(6)
- modify_date — datetime(6)
- address — varchar(255)
- average_score — double
- contact — varchar(255)
- latitude — double
- longitude — double
- name — varchar(255)
- category_id — bigint(20) — Foreign key → category.id
spot_hashtag
- id — bigint(20) — Primary key — NOT NULL
- create_date — datetime(6)
- modify_date — datetime(6)
- hashtag_id — bigint(20) — Foreign key → hashtag.id
- spot_id — bigint(20) — Foreign key → spot.id
spot_image
- id — bigint(20) — Primary key — NOT NULL
- create_date — datetime(6)
- modify_date — datetime(6)
- image_id — bigint(20) — Foreign key → _file.id
- spot_id — bigint(20) — Foreign key → spot.id