DevCourse_1
Tables (4)
customers
- id — BIGINT — Primary key — NOT NULL
- address — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- postcode — VARCHAR(255) — NOT NULL
order_item
- id — BIGINT — Primary key — NOT NULL
- count — INT
- order_id — BIGINT — Foreign key → orders.id
- product_id — BIGINT — Foreign key → products.id
orders
- id — BIGINT — Primary key — NOT NULL
- create_date — DATETIME — NOT NULL
- customer_id — BIGINT — Foreign key → customers.id
products
- id — BIGINT — Primary key — NOT NULL
- description — TEXT
- image_path — VARCHAR(255) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- price — INT — NOT NULL
- status — ENUM('ACTIVE','DELETED') — NOT NULL