mitchinmat v2
Tables (6)
comment
- id — bigint — Primary key — NOT NULL
- created_date — datetime(6)
- modified_date — datetime(6)
- content — varchar(255)
- place_id — bigint — Foreign key → place.id
- user_id — bigint — Foreign key → user.id
- id (id2) — bigint — Foreign key → user.id — NOT NULL
friend
- id — bigint — Primary key — NOT NULL
- user_id1 — bigint
- user_id2 — bigint — Foreign key → user.id
- created_date — datetime(6)
- modified_date — datetime(6)
- view_status — tinyint(1)
- id (id22) — bigint — Foreign key → user.id — NOT NULL
friend_of_friend
- user_id — bigint — Primary key — NOT NULL
- friend_id_list — varchar(255)
- created_date — datetime(6)
- modified_date — datetime(6)
good_place
- user_id — bigint — Foreign key → user.id — NOT NULL
- place_id — bigint — Foreign key → place.id — NOT NULL
- id (id2) — bigint — Foreign key → user.id — NOT NULL
- custom_tag — varchar(255)
- memo — varchar(255)
- created_date — datetime(6)
- modified_date — datetime(6)
- public_status — bit(1) — NOT NULL
place
- id — bigint — Primary key — NOT NULL
- x — double
- y — double
- created_date — datetime(6)
- modified_date — datetime(6)
- address_name — varchar(255)
- phone — varchar(255)
- place_name — varchar(255)
- place_url — varchar(255)
- road_address_name — varchar(255)
- road_find_url — varchar(255)
- search_url — varchar(255)
- image_url — varchar(255)
- operation_time — varchar(255)
- tags — varchar(255)
- total_kakao_reviews — int
- kakao_review_score — double
- cate_name_1 (cate_nm_1) — varchar(255)
- cate_name_2 (cate_nm_2) — varchar(255)
- cate_name_3 (cate_nm_3) — varchar(255)
- cate_name_4 (cate_nm_4) — varchar(255)
- cate_name_5 (cate_nm_5) — varchar(255)
user
- id — bigint — Primary key — NOT NULL
- id (id2) — bigint — Foreign key → friend.id — NOT NULL
- created_date — datetime(6)
- good_place_count — bigint
- inactive_date — datetime(6)
- modified_date — datetime(6)
- user_id — bigint — Foreign key → friend_of_friend.user_id
- oauth2id — varchar(255)
- profile_image — varchar(255)
- username — varchar(255)
- provider — enum('KAKAO') — NOT NULL
- role — enum('ADMIN','USER','ANONYMOUS')
- status — enum('ACTIVE','INACTIVE') — NOT NULL