project_sample

Tables (3)

Category

  • category_id — INT
  • category_name — VARCHAR(255) — NOT NULL
  • description — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

Product_Category

  • Key2 — Primary key — NOT NULL
  • Key — Primary key — NOT NULL
  • product_id — INT
  • category_id — INT
  • Field
  • Field2

post

  • name — VARCHAR(255) — NOT NULL
  • description — TEXT
  • price — DECIMAL(10, 2) — NOT NULL
  • stock — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • Key2 — Foreign key → Product_Category.Key2 — NOT NULL
  • Key — Foreign key → Product_Category.Key — NOT NULL
  • post_id — INT