개척인들DB
테이블 (16)
board_entity_image_urls
- board_entity_board_give_id — BIGINT — 외래 키 → board_give_table.board_give_id — 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 — 외래 키 → comment_table.comment_id — 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 — 외래 키 → comment_table.comment_id
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 — 외래 키 → community_board.board_id — NOT NULL
- board_images — LONGTEXT
community_likes_entity_board_id
- community_likes_entity_user_seq — VARCHAR(255) — 외래 키 → community_likes_table.user_seq — 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) — 외래 키 → user_com_view_log_entity.user_seq
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) — 외래 키 → user_likes_table.user_seq — NOT NULL
- board_give_id — BIGINT