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