market
Tables (7)
Account
- id — BIGINT — Primary key
- Key — Primary key — NOT NULL
- user_account (user_id) — BIGINT — Foreign key → User.id
- balance — DECIMAL(10, 2)
ChatMessage
- id — INT — Primary key
- chatroom_product (chatroom_id) — BIGINT — Foreign key → ChatRoom.chatroom_product
- sender_id — INT
- message — TEXT
- created_at — TIMESTAMP
- Field
ChatRoom
- id — BIGINT — Primary key
- user-chat (seller_id, buyer_id) — INT — Foreign key → User.id
- chatroom_product (product_id) — INT — Foreign key → Product.id
- seller_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- Key — NOT NULL
Product
- id — BIGINT — Primary key
- name — VARCHAR(100) — NOT NULL
- price — DECIMAL(10, 2) — NOT NULL
- seller_id — INT
ProductImage
- id — INT — Primary key
- product_id — INT
- image_url — VARCHAR(255) — NOT NULL
Trade (Transaction)
- id — BIGINT — Primary key
- product_trade (product_id) — BIGINT — Foreign key → Product.id
- buyer_id — INT
- seller_id — INT
- amount — DECIMAL(10, 2) — NOT NULL
- status — ENUM('pending', 'completed', 'failed')
- product_id (product_if) — BIGINT — NOT NULL
User
- id — BIGINT — Primary key
- username — VARCHAR(50) — NOT NULL
- password — VARCHAR(100) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- address — VARCHAR(255)
- role — ENUM('admin', 'user')