Snp-규성
테이블 (24)
common_code
- cc_no — bigint — NOT NULL
- cc_category — varchar(255) — NOT NULL
- cc_category_info — varchar(255) — NOT NULL
- cc_info — varchar(255) — NOT NULL
- cc_name — varchar(255) — NOT NULL
devtalk
- devtalk_id — 기본 키 — NOT NULL
- category_no — bigint — NOT NULL
- created_at — datetime(6) — NOT NULL
- created_by — bigint
- deleted_at — datetime(6)
- member_id — bigint — NOT NULL
- updated_at — datetime(6) — NOT NULL
- updated_by — bigint
- summary — varchar(255)
- thumbnail_url — varchar(2048)
- title — varchar(255) — NOT NULL
- content — text
- status — enum — NOT NULL
- deleted_by — bigint
devtalkSnapshot
- devTalkSnapshot_id — 기본 키 — NOT NULL
- devtalk_id — 외래 키 → devtalk.devtalk_id — NOT NULL
- title — varchar(255) — NOT NULL
- content — text
- category_no — bigint — NOT NULL
- summary — varchar(255)
- created_at — datetime(6) — NOT NULL
- created_by — bigint
- updated_at — datetime(6) — NOT NULL
- updated_by — bigint
devtalk_bookmark
- bookmark_id — bigint
- created_at — datetime(6) — NOT NULL
- created_by — bigint
- devtalk_id — bigint — NOT NULL
- member_id — bigint — NOT NULL
- updated_at — datetime(6) — NOT NULL
- updated_by — bigint
devtalk_comment
- comment_id — bigint
- created_at — datetime(6) — NOT NULL
- created_by — bigint
- deleted_at — datetime(6)
- devtalk_id — bigint — NOT NULL
- member_id — bigint — NOT NULL
- updated_at — datetime(6) — NOT NULL
- updated_by — bigint
- content — text — NOT NULL
- deleted_by — bigint
feed
- created_at — datetime(6) — NOT NULL
- created_by — bigint
- deleted_at — datetime(6)
- feed_id — bigint
- member_id — bigint — NOT NULL
- updated_at — datetime(6) — NOT NULL
- updated_by — bigint
- content — text
- deleted_by — bigint
image
- is_banner_active — bit — NOT NULL
- sort_order — int — NOT NULL
- created_at — datetime(6) — NOT NULL
- created_by — bigint
- deleted_at — datetime(6)
- file_size — bigint — NOT NULL
- height — bigint
- image_id — bigint
- reference_id — bigint — NOT NULL
- updated_at — datetime(6) — NOT NULL
- updated_by — bigint
- width — bigint
- image_name — binary(16) — NOT NULL
- file_extension — varchar(255) — NOT NULL
- category — enum — NOT NULL
- deleted_by — bigint
member
- auth_no — int — NOT NULL
- profile_completed — bit — NOT NULL
- rank_no — int
- workplace_no — int
- created_at — datetime(6) — NOT NULL
- created_by — bigint
- deleted_at — datetime(6)
- member_id — bigint
- updated_at — datetime(6) — NOT NULL
- updated_by — bigint
- email — varchar(255) — NOT NULL
- name — varchar(255) — NOT NULL
- phone_number — varchar(255)
- profile_image_url — varchar(255)
- provider_id — varchar(255)
- provider — enum
- deleted_by — bigint
monthly_top_restaurant
- monthly_top_id — bigint
- created_at — datetime(6) — NOT NULL
- created_by — bigint
- updated_at — datetime(6) — NOT NULL
- updated_by — bigint
- average_rating — double — NOT NULL
- review_count — int — NOT NULL
- year_month — int — NOT NULL
- restaurant_id — bigint — NOT NULL
monthly_top_reviewer
- monthly_reviewer_id — bigint
- created_at — datetime(6) — NOT NULL
- created_by — bigint
- updated_at — datetime(6) — NOT NULL
- updated_by — bigint
- review_count — int — NOT NULL
- year_month — int — NOT NULL
- member_id — bigint — NOT NULL
notice
- created_at — datetime(6) — NOT NULL
- created_by — bigint
- deleted_at — datetime(6)
- member_id — bigint — NOT NULL
- notice_id — bigint
- updated_at — datetime(6) — NOT NULL
- updated_by — bigint
- title — varchar(255) — NOT NULL
- content — text — NOT NULL
- visibility — enum — NOT NULL
- deleted_by — bigint
notice_target
- id — bigint
- notice_id — bigint — NOT NULL
- target_rank_no — int — NOT NULL
notification
- category_no — int — NOT NULL
- is_read — bit — NOT NULL
- created_at — datetime(6) — NOT NULL
- created_by — bigint
- deleted_at — datetime(6)
- notification_id — bigint
- receiver_id — bigint — NOT NULL
- reference_id — bigint — NOT NULL
- sender_id — bigint — NOT NULL
- updated_at — datetime(6) — NOT NULL
- updated_by — bigint
- content — varchar(255) — NOT NULL
- target_url — varchar(255) — NOT NULL
- deleted_by — bigint
recommendation
- recommendation_id — bigint
- created_at — datetime(6) — NOT NULL
- created_by — bigint
- updated_at — datetime(6) — NOT NULL
- updated_by — bigint
- deleted_at — datetime(6)
- deleted_by — bigint
- content — text — NOT NULL
- custom_version — int — NOT NULL
- version — int — NOT NULL
- restaurant_id — bigint — NOT NULL
recommendation_history
- history_id — bigint
- created_at — datetime(6) — NOT NULL
- created_by — bigint
- updated_at — datetime(6) — NOT NULL
- updated_by — bigint
- deleted_at — datetime(6)
- deleted_by — bigint
- content — text — NOT NULL
- version — int — NOT NULL
- recommendation_id — bigint — NOT NULL
refresh_token
- created_at — datetime(6) — NOT NULL
- expiration — datetime(6) — NOT NULL
- member_id — bigint — NOT NULL
- refresh_token_id — bigint
- token_value — varchar(255) — NOT NULL
report
- report_id — bigint
- created_at — datetime(6) — NOT NULL
- created_by — bigint
- updated_at — datetime(6) — NOT NULL
- updated_by — bigint
- processed — bit — NOT NULL
- reason — text — NOT NULL
- report_type — enum — NOT NULL
- target_id — bigint — NOT NULL
resized_image
- is_banner_active — bit — NOT NULL
- sort_order — int — NOT NULL
- created_at — datetime(6) — NOT NULL
- created_by — bigint
- deleted_at — datetime(6)
- file_size — bigint — NOT NULL
- image_id — bigint
- reference_id — bigint — NOT NULL
- resizing_height — bigint
- resizing_width — bigint
- updated_at — datetime(6) — NOT NULL
- updated_by — bigint
- image_name — binary(16) — NOT NULL
- file_extension — varchar(255) — NOT NULL
- category — enum — NOT NULL
- deleted_by — bigint
restaurant
- average_rating — double — NOT NULL
- can_reserve — bit
- category_no — int — NOT NULL
- latitude — double
- longitude — double
- workplace_no — int — NOT NULL
- created_at — datetime(6) — NOT NULL
- created_by — bigint
- deleted_at — datetime(6)
- restaurant_id — bigint
- updated_at — datetime(6) — NOT NULL
- updated_by — bigint
- address — varchar(255) — NOT NULL
- business_hours — varchar(255)
- name — varchar(255) — NOT NULL
- phone_number — varchar(255)
- deleted_by — bigint
- kakao_place_id — varchar(255) — NOT NULL
- status — enum — NOT NULL
- sync_failure_count — int
- bookmark_count — bigint — NOT NULL
- review_count — bigint — NOT NULL
restaurant_bookmark
- bookmark_id — bigint
- created_at — datetime(6) — NOT NULL
- created_by — bigint
- member_id — bigint — NOT NULL
- restaurant_id — bigint — NOT NULL
- updated_at — datetime(6) — NOT NULL
- updated_by — bigint
restaurant_review
- rating — int — NOT NULL
- created_at — datetime(6) — NOT NULL
- created_by — bigint
- deleted_at — datetime(6)
- member_id — bigint — NOT NULL
- restaurant_id — bigint — NOT NULL
- review_id — bigint
- updated_at — datetime(6) — NOT NULL
- updated_by — bigint
- content — text
- deleted_by — bigint
review_keyword
- keyword_no — int — NOT NULL
- created_at — datetime(6) — NOT NULL
- created_by — bigint
- deleted_at — datetime(6)
- review_id — bigint — NOT NULL
- review_keyword_id — bigint
- updated_at — datetime(6) — NOT NULL
- updated_by — bigint
- deleted_by — bigint
review_like
- created_at — datetime(6) — NOT NULL
- created_by — bigint
- member_id — bigint — NOT NULL
- review_id — bigint — NOT NULL
- review_like_id — bigint
- updated_at — datetime(6) — NOT NULL
- updated_by — bigint
weekly_hot_restaurant
- weekly_hot_id — bigint
- created_at — datetime(6) — NOT NULL
- created_by — bigint
- updated_at — datetime(6) — NOT NULL
- updated_by — bigint
- average_rating — double — NOT NULL
- bookmark_count — int — NOT NULL
- ranking — int — NOT NULL
- review_count — int — NOT NULL
- score — double — NOT NULL
- week_number — int — NOT NULL
- week_year — int — NOT NULL
- workplace_no — int — NOT NULL
- restaurant_id — bigint — NOT NULL