lastmarket

Tables (12)

ban

  • id — bigint(20) — Primary key — NOT NULL
  • created_date_time — datetime(6)
  • last_modified_date_time — datetime(6)
  • from_id — bigint(20) — Foreign key → member.id
  • to_id — bigint(20) — Foreign key → member.id

buyer_review

  • send_review_id — bigint(20) — Primary key — NOT NULL
  • created_date_time — datetime(6)
  • last_modified_date_time — datetime(6)
  • review_template — varchar(255)
  • buyer_id — bigint(20) — Foreign key → member.id
  • seller_id — bigint(20) — Foreign key → member.id
  • trade_id — bigint(20) — Foreign key → trade.id

category

  • id — bigint(20) — Primary key — NOT NULL
  • category_name — varchar(255)

chatting

  • id — bigint(20) — Primary key — NOT NULL
  • created_date_time — datetime(6)
  • last_modified_date_time — datetime(6)
  • buyer_id — bigint(20) — Foreign key → member.id
  • product_id — bigint(20) — Foreign key → product.id
  • seller_id — bigint(20) — Foreign key → member.id

favorite

  • id — bigint(20) — Primary key — NOT NULL
  • created_date_time — datetime(6)
  • last_modified_date_time — datetime(6)
  • member_id — bigint(20) — Foreign key → member.id
  • product_id — bigint(20) — Foreign key → product.id

image

  • id — bigint(20) — Primary key — NOT NULL
  • created_date_time — datetime(6)
  • last_modified_date_time — datetime(6)
  • image_name — varchar(255)
  • imageurl — varchar(255)

location

  • dong_code — varchar(255) — Primary key — NOT NULL
  • dong — varchar(255)
  • gugun — varchar(255)
  • sido — varchar(255)

member

  • id — bigint(20) — Primary key — NOT NULL
  • created_date_time — datetime(6)
  • last_modified_date_time — datetime(6)
  • job — int(11)
  • nickname — varchar(255)
  • role — varchar(20) — NOT NULL
  • username — varchar(255)
  • location_dong_code — varchar(255) — Foreign key → location.dong_code
  • profile_id — bigint(20) — Foreign key → image.id

product

  • id — bigint(20) — Primary key — NOT NULL
  • created_date_time — datetime(6)
  • last_modified_date_time — datetime(6)
  • content — varchar(255)
  • deal_state — int(11)
  • favorite_cnt — int(11)
  • instant_price — bigint(20)
  • live_time — datetime(6)
  • starting_price — bigint(20)
  • title — varchar(255)
  • category_id — bigint(20) — Foreign key → category.id
  • dong_code — varchar(255) — Foreign key → location.dong_code
  • seller_id — bigint(20) — Foreign key → member.id

product_image

  • product_image_id — bigint(20) — Primary key — NOT NULL
  • created_date_time — datetime(6)
  • last_modified_date_time — datetime(6)
  • image_id — bigint(20) — Foreign key → image.id
  • product_id — bigint(20) — Foreign key → product.id

seller_review

  • receive_review_id — bigint(20) — Primary key — NOT NULL
  • created_date_time — datetime(6)
  • last_modified_date_time — datetime(6)
  • review_template — varchar(255)
  • buyer_id — bigint(20) — Foreign key → member.id
  • seller_id — bigint(20) — Foreign key → member.id
  • trade_id — bigint(20) — Foreign key → trade.id

trade

  • id — bigint(20) — Primary key — NOT NULL
  • created_date_time — datetime(6)
  • last_modified_date_time — datetime(6)
  • buyer_id — bigint(20) — Foreign key → member.id
  • product_id — bigint(20) — Foreign key → product.id
  • seller_id — bigint(20) — Foreign key → member.id