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