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)