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