ssss
Tables (15)
badge
- id — bigint
- create_date — datetime(6)
- modify_date — datetime(6)
- badge_img — varchar(255)
- badge_name — varchar(255)
- user_id — bigint
comment
- id — bigint
- create_date — datetime(6)
- modify_date — datetime(6)
- content — varchar(255) — NOT NULL
- feed_id — bigint
- review_id — bigint
- user_id — bigint
feed
- id — bigint
- create_date — datetime(6)
- modify_date — datetime(6)
- comment_cnt — int — NOT NULL
- content — varchar(255)
- create_by_me — bit — NOT NULL
- is_liked — bit — NOT NULL
- is_saved — bit — NOT NULL
- like_cnt — int — NOT NULL
- user_id — bigint — NOT NULL
feed_tag_map
- feed_tag_map_id — bigint
- create_date — datetime(6)
- modify_date — datetime(6)
- feed_id — bigint
- tag_id — bigint
image
- id — bigint
- create_date — datetime(6)
- modify_date — datetime(6)
- img_url — varchar(255)
- feed_id — bigint
- review_id — bigint
- user_id — bigint
- team_img_url — varchar(255)
likes
- id — bigint
- like_check — bit — NOT NULL
- feed_id — bigint
- review_id — bigint
- user_id — bigint
mountain
- id — bigint
- difficulty — varchar(255)
- explanation — varchar(255)
- high — varchar(255)
- img — varchar(255)
- lattitue — varchar(255)
- location — varchar(255)
- longtitue — varchar(255)
- name — varchar(255)
- season — varchar(255)
- theme — varchar(255)
review
- id — bigint
- create_date — datetime(6)
- modify_date — datetime(6)
- agree — bit — NOT NULL
- comment_cnt — int — NOT NULL
- content — varchar(255)
- created_by_me — bit — NOT NULL
- departure_day — varchar(255)
- is_liked — bit — NOT NULL
- is_saved — bit — NOT NULL
- like_cnt — int — NOT NULL
- mountain_id — bigint
- team_id — bigint
- user_id — bigint — NOT NULL
- type — enum('MREVIEW', 'TREVIEW')
review_tag_map
- review_tag_map_id — bigint
- review_id — bigint
- tag_id — bigint
tag
- tag_id — bigint
- create_date — datetime(6)
- modify_date — datetime(6)
- name — varchar(255) — NOT NULL
team
- id — bigint
- create_date — datetime(6)
- modify_date — datetime(6)
- chat_link — varchar(255)
- chat_password — varchar(255)
- content — varchar(255)
- create_by_me — bit — NOT NULL
- departure_day — varchar(255)
- gender — enum('all', 'female', 'male')
- title — varchar(255)
- mountain_id — bigint
- user_id — bigint — NOT NULL
- team_image — varchar(255)
team_age_range
- team_id — bigint — NOT NULL
- age_range — enum('fifties', 'fourties', 'sixties', 'teenager', 'thirties', 'twenties')
user
- user_id — bigint — Primary key — NOT NULL
- create_date — datetime(6)
- modify_date — datetime(6)
- age_range — varchar(255)
- area_interest — varchar(255)
- gender — varchar(255)
- introduction — varchar(255)
- location_agree — varchar(255)
- nickname — varchar(255)
- oauth_provider — enum('KAKAO', 'NAVER')
- password — varchar(255)
- privacy_agree — varchar(255)
- profile_image — varchar(255)
- roles — varbinary(255)
- user_account — varchar(255)
- user_level — bigint
user_meeting
- id — bigint
- create_date — datetime(6)
- modify_date — datetime(6)
- team_id — bigint
- user_user_id — bigint
user_review
- id — bigint
- create_date — datetime(6)
- modify_date — datetime(6)
- review_id — bigint
- user_user_id — bigint