Plie Market
Tables (3)
Article
- ID — BIGINT — Primary key — NOT NULL
- title (Field) — VARCHAR(100) — NOT NULL
- price (Field2) — INT — NOT NULL
- category (Field3) — VARCHAR(50) — NOT NULL
- condition (Field4) — VARCHAR(50) — NOT NULL
- trade_method (Field5) — VARCHAR(50) — NOT NULL
- view_count (Field6) — INT — NOT NULL
- image_url (Field8) — VARCHAR(255) — NOT NULL
- product_name (Field9) — VARCHAR(100) — NOT NULL
- size (Field10) — VARCHAR(20)
- color (Field11) — VARCHAR(30)
- created_at (Field7) — DATETIME — NOT NULL
- user_id (ID2) — BIGINT — Foreign key → User.ID — NOT NULL
- updated_at (Field12) — DATETIME — NOT NULL
Comment
- ID — BIGINT — Primary key — NOT NULL
- user_id (ID2) — BIGINT — Foreign key → User.ID — NOT NULL
- article_id (ID3) — BIGINT — Foreign key → Article.ID — NOT NULL
- content (Field) — TEXT — NOT NULL
User
- ID — BIGINT — Primary key — NOT NULL
- nickname (Field) — VARCHAR(50) — NOT NULL — unique
- email (Field2) — VARCHAR(100) — NOT NULL — unique
- password (Field3) — VARCHAR(255) — NOT NULL