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