개척인들DB - 2023-10-10 08:14:06

테이블 (16)

board_entity_image_urls

  • board_entity_board_give_id — BIGINT — 외래 키 — NOT NULL
  • image_urls — LONGTEXT

board_give_table

  • board_give_id — BIGINT — 기본 키 — NOT NULL
  • board_title — VARCHAR(255)
  • book_story — LONGTEXT
  • category_id — VARCHAR(255)
  • city_id — VARCHAR(255)
  • date — VARCHAR(255)
  • direct_index — VARCHAR(255)
  • like_count — BIGINT
  • meet_want_location — VARCHAR(255)
  • parcel_index — VARCHAR(255)
  • state_cover — VARCHAR(255)
  • state_notes — VARCHAR(255)
  • state_page_color_change — VARCHAR(255)
  • state_page_damage — VARCHAR(255)
  • state_underscore — VARCHAR(255)
  • state_written_name — VARCHAR(255)
  • sub_category_id — VARCHAR(255)
  • user_name — VARCHAR(255)
  • user_seq — VARCHAR(255)

chat_board

  • post_id — BIGINT — 기본 키 — NOT NULL
  • content — VARCHAR(255)
  • new_category1 — VARCHAR(255)
  • new_category2 — VARCHAR(255)

comment_image

  • comment_id — BIGINT — 외래 키 — NOT NULL
  • image_url — VARCHAR(255)

comment_table

  • comment_id — BIGINT — 기본 키 — NOT NULL
  • board_id — BIGINT
  • content — VARCHAR(1000)
  • created_at — DATETIME(6) — NOT NULL
  • nick_name — VARCHAR(255)
  • updated_at — DATETIME(6) — NOT NULL
  • user_image_url — VARCHAR(255)
  • user_seq — VARCHAR(255)
  • parent_comment_id — BIGINT — 외래 키

community_board

  • board_id — BIGINT — 기본 키 — NOT NULL
  • dtype — VARCHAR(31) — NOT NULL
  • user_grade — VARCHAR(255)
  • user_image_url — LONGTEXT
  • board_story — LONGTEXT
  • board_title — VARCHAR(255)
  • category_id — VARCHAR(255)
  • date — VARCHAR(255)
  • like_count — BIGINT
  • nick_name — VARCHAR(255)
  • user_seq — VARCHAR(255)

community_entity_board_images

  • community_entity_board_id — BIGINT — 외래 키 — NOT NULL
  • board_images — LONGTEXT

community_likes_entity_board_id

  • community_likes_entity_user_seq — VARCHAR(255) — 외래 키 — NOT NULL
  • board_id — BIGINT

community_likes_table

  • user_seq — VARCHAR(255) — 기본 키 — NOT NULL

final_com_distribution_entity

  • id — BIGINT — 기본 키 — NOT NULL
  • view_cnt_daily — FLOAT
  • view_cnt_study — FLOAT
  • user_seq — VARCHAR(255) — 외래 키

final_distribution_entity

  • id — BIGINT — 기본 키 — NOT NULL
  • view_cnt_category1 — FLOAT
  • view_cnt_category2 — FLOAT
  • user_seq — VARCHAR(255) — 외래 키 → user_view_log_entity.user_seq — NOT NULL

user_com_view_log_entity

  • user_seq — VARCHAR(255) — 기본 키 — NOT NULL
  • view_cnt_daily — FLOAT
  • view_cnt_study — FLOAT

user_info_firebase (Untitled)

  • Uid (uid) — 기본 키 — NOT NULL
  • ProfileImageUrl
  • email
  • userName
  • password
  • user_grade

user_likes_table

  • user_seq — VARCHAR(255) — 기본 키 — NOT NULL

user_view_log_entity

  • user_seq — VARCHAR(255) — 기본 키 — NOT NULL
  • view_cnt_category1 — FLOAT
  • view_cnt_category2 — FLOAT

users_likes_entity_board_give_id

  • users_likes_entity_user_seq — VARCHAR(255) — 외래 키 — NOT NULL
  • board_give_id — BIGINT