ㄹㄹ
Tables (4)
Comment
- id — INT — Primary key — NOT NULL
- content — TEXT
- create_date — DATETIME
- user_id — INT — Foreign key → User.id — NOT NULL
- product_id — INT — Foreign key → Product.id — NOT NULL
ItemOrder
- id — INT — Primary key — NOT NULL
- quantity — INT
- order_date — DATETIME
- product_Id — INT — Foreign key → Product.id — NOT NULL
- user_id — INT — Foreign key → User.id — NOT NULL
Product
- id — INT — Primary key — NOT NULL
- title — VARCHAR(100)
- description — TEXT
- price — DECIMAL(10,2)
- stock — INT
- seller_id — INT — Foreign key → User.id — NOT NULL
User
- id — INT — Primary key — NOT NULL
- password — VARCHAR(255)
- email — VARCHAR(100)
- nickname — VARCHAR(50)
- role — VARCHAR(20)