view buy me
Tables (14)
auction_results
- result_id — INT
- auction_id — INT — NOT NULL
- winner_member_id — INT
- winning_bid_amount — DECIMAL(10,2)
- total_bids — INT
- status — ENUM('IN_PROGRESS', 'COMPLETED', 'NO_WINNER', 'CANCELLED')
- completed_at — TIMESTAMP
- created_at — TIMESTAMP
auctions
- auction_id — BIGINT — Primary key — NOT NULL
- product_id — BIGINT — NOT NULL
- starting_price — DECIMAL(10, 2) — NOT NULL
- start_time — TIMESTAMP — NOT NULL
- end_time — TIMESTAMP — NOT NULL
- period — ENUM('3', '5', '7', '10')
- status — ENUM('OPEN', 'AWARD', 'CLOSE' ,'CANCELLED')
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
bids
- bid_id — BIGINT — Primary key — NOT NULL
- auction_id — BIGINT — NOT NULL
- member_id — BIGINT — NOT NULL
- bid_price — DECIMAL(10, 2) — NOT NULL
- bid_time — TIMESTAMP
- status — ENUM('ACTIVE', 'CANCELED', 'AWARD')
- created_at (careated_at) — TIMESTAMP
- updated_at — TIMESTAMP
favorite_products
- favorite_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Primary key — NOT NULL
- product_id — BIGINT — NOT NULL
- deleted — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
files
- id — BIGINT
- filename — VARCHAR(255) — NOT NULL
- file_path — VARCHAR(500) — NOT NULL
- file_size — BIGINT — NOT NULL
- content_type — VARCHAR(100) — NOT NULL
- status — VARCHAR(50)
- created_at — TIMESTAMP
- uploaded_at — TIMESTAMP
members
- member_id (memver_id) — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255) — Primary key — NOT NULL
- nickname — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- phone — VARCHAR(15)
- address — VARCHAR(255)
- role — ENUM('USER', 'ADMIN')
- status — ENUM('ACTIVE', 'INACTIVE', 'BANNED', 'DELETED')
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
payments
- payment_id — BIGINT
- settlement_id — BIGINT — NOT NULL
- payment_method — ENUM('CARD', 'TRANSFER') — NOT NULL
- payment_amount — DECIMAL(10, 2) — NOT NULL
- payment_status — ENUM('PENDING', 'COMPLETED', 'FAILED', 'CANCELLED', 'REFUNDED')
- transaction_id — VARCHAR(200)
- payment_gateway — VARCHAR(100)
- paid_at — TIMESTAMP
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
product_categories
- category_id (Key) — BIGINT — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
product_images
- image_id (Key) — BIGINT — Primary key — NOT NULL
- product_id — BIGINT
- file_id — BIGINT
products
- product_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- description — TEXT
- thumbnail_url — VARCHAR(255) — NOT NULL
- category — VARCHAR(100) — NOT NULL
- price — DECIMAL(10, 2) — NOT NULL
- available — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
push_notifications
- notification_id (Key) — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — NOT NULL
- message — TEXT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
seller_reviews
- id — BIGINT
- reviewer_id — BIGINT — NOT NULL
- seller_id — BIGINT — NOT NULL
- product_id — BIGINT
- rating — INT
- comment — TEXT — EX
- created_at — DATETIME
settlements
- settlement_id — BIGINT
- auction_id — BIGINT — NOT NULL
- buyer_id — BIGINT — NOT NULL
- status — ENUM('AWARD', 'PENDING', 'REJECTED', 'FAILED') — NOT NULL
- payment_deadline — DATETIME — NOT NULL
- rejected_reason — TEXT
- price — INT
- paid_at — DATETIME
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
shipping
- shipping_id — INT
- order_id — INT — NOT NULL
- tracking_number — VARCHAR(100)
- shipping_company — VARCHAR(100)
- recipient_name — VARCHAR(100) — NOT NULL
- recipient_phone — VARCHAR(20) — NOT NULL
- shipping_address — VARCHAR(500) — NOT NULL
- shipping_status — ENUM('PREPARING', 'SHIPPED', 'IN_TRANSIT', 'OUT_FOR_DELIVERY', 'DELIVERED', 'FAILED', 'RETURNED')
- shipping_method — ENUM('STANDARD', 'EXPRESS', 'OVERNIGHT')
- shipping_cost — DECIMAL(10,2)
- estimated_delivery_date — DATE
- actual_delivery_date — DATETIME
- special_instructions — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP