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