board
Tables (6)
board
- board_id — BIGINT(20) — Primary key — NOT NULL
- created_date — DATETIME(6)
- last_modified_date — DATETIME(6)
- created_by — VARCHAR(255)
- last_modified_by — VARCHAR(255)
- detail_area — VARCHAR(255)
- representative_area — VARCHAR(255)
- content — VARCHAR(10000)
- group_id — INT(11) — NOT NULL
- price — INT(11) — NOT NULL
- tag_sum — VARCHAR(255)
- store_file_name — VARCHAR(255)
- upload_file_name — VARCHAR(255)
- title — VARCHAR(255)
- view_cnt — BIGINT(20)
- member_id — BIGINT(20) — Foreign key → member.member_id
- INDEX — `FKsds8ox89wwf6aihinar49rmfy`
choice_board
- choice_board_id — BIGINT(20) — Primary key — NOT NULL
- board_id — BIGINT(20) — Foreign key → board.board_id
- member_id — BIGINT(20) — Foreign key → member.member_id
- INDEX — `FKpxsuvt0d33y2o8xflh56kp69u`
- INDEX — `FKmfuoj6mdvohq2qqihu0d7k5fm`
member
- member_id — BIGINT(20) — Primary key — NOT NULL
- created_date — DATETIME(6)
- last_modified_date — DATETIME(6)
- email — VARCHAR(255)
- name — VARCHAR(255)
- password — VARCHAR(255)
- provider — VARCHAR(255)
- provider_id — VARCHAR(255)
- role — VARCHAR(255)
- username — VARCHAR(255)
reply
- reply_id — BIGINT(20) — Primary key — NOT NULL
- created_date — DATETIME(6)
- last_modified_date — DATETIME(6)
- created_by — VARCHAR(255)
- last_modified_by — VARCHAR(255)
- reply_text — VARCHAR(255)
- board_id — BIGINT(20) — Foreign key → board.board_id
- member_id — BIGINT(20) — Foreign key → member.member_id
- INDEX — `FKcs9hiip0bv9xxfrgoj0lwv2dt`
- INDEX — `FKen6vrmi5oth4bg6ybfc202fmu`
search_info
- search_info_id — BIGINT(20) — Primary key — NOT NULL
- category_option1 — INT(11) — NOT NULL
- category_option2 — INT(11) — NOT NULL
- category_option3 — INT(11) — NOT NULL
- category_option4 — INT(11) — NOT NULL
- price_option1 — INT(11) — NOT NULL
- price_option2 — INT(11) — NOT NULL
- price_option3 — INT(11) — NOT NULL
- price_option4 — INT(11) — NOT NULL
- regions_option1 — INT(11) — NOT NULL
- regions_option2 — INT(11) — NOT NULL
- regions_option3 — INT(11) — NOT NULL
- regions_option4 — INT(11) — NOT NULL
- regions_option5 — INT(11) — NOT NULL
- regions_option6 — INT(11) — NOT NULL
- regions_option7 — INT(11) — NOT NULL
- regions_option8 — INT(11) — NOT NULL
- regions_option9 — INT(11) — NOT NULL
- tag_option1 — INT(11) — NOT NULL
- tag_option2 — INT(11) — NOT NULL
- tag_option3 — INT(11) — NOT NULL
- tag_option4 — INT(11) — NOT NULL
- INDEX — `FKs5da9ajjlxjsjw5bm0ue20mws`
- member_id — BIGINT(20) — Foreign key → member.member_id — NOT NULL
search_info_order_map
- order_map_key — VARCHAR(255) — Primary key — NOT NULL
- search_info_id — BIGINT(20) — Foreign key → search_info.search_info_id — NOT NULL
- order_map — INT(11)