offer-erd

Tables (7)

article

  • article_id — bigint — Primary key — NOT NULL
  • category_code — integer
  • content — TEXT
  • created_date — timestamp
  • like_count — integer
  • main_image_url — TEXT
  • modified_date — timestamp
  • price — integer
  • product_status_code — integer
  • quantity — integer
  • title — varchar(255)
  • trade_area — varchar(255)
  • trade_method_code — integer
  • trade_status_code — integer
  • view_count — integer
  • writer_id — bigint

like_article

  • like_article_id — bigint — Primary key — NOT NULL
  • article_id — bigint
  • member_id — bigint

member

  • member_id — bigint — Primary key — NOT NULL
  • login_id — varchar(255)
  • password — varchar(255)

message_room

  • message_room_id — bigint — Primary key — NOT NULL
  • create_date — datetime(6)

offer

  • offer_id — bigint — Primary key — NOT NULL
  • created_date — timestamp
  • is_selected — tinyint(1)
  • price — integer
  • article_id — bigint
  • offerer_id — bigint

product_image

  • product_image_id — bigint — Primary key — NOT NULL
  • image_url — varchar(255)
  • article_id — bigint

review

  • review_id — bigint
  • content — TEXT
  • created_date — timestamp
  • is_reviewee_buyer — tinyint(1)
  • score — integer
  • article_id — bigint
  • reviewee_id — bigint
  • reviewer_id — bigint