model1
Tables (8)
admin
- id — BIGINT — Primary key — NOT NULL
- admin_id — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
notification
- id — BIGINT — Primary key — NOT NULL
- order_id — BIGINT — Foreign key → orders.id — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
notification_read
- id — BIGINT — Primary key — NOT NULL
- notification_id — BIGINT — Foreign key → notification.id — NOT NULL
- admin_id — VARCHAR(255) — NOT NULL
- read_at — DATETIME — NOT NULL
order_item
- id — BIGINT — Primary key — NOT NULL
- order_id — BIGINT — Foreign key → orders.id — NOT NULL
- product_id — BIGINT — Foreign key → product.id — NOT NULL
- quantity — BIGINT — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
orders
- id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- addressLine1 — VARCHAR(255) — NOT NULL
- addressLine2 — VARCHAR(255) — NOT NULL
- postal_code — VARCHAR(255) — NOT NULL
- order_status — VARCHAR(255) — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
product
- id — BIGINT — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- description — VARCHAR(255) — NOT NULL
- price — INT — NOT NULL
- stock — INT — NOT NULL
- thumbnail — VARCHAR(255) — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
product_img
- id — BIGINT — Primary key — NOT NULL
- product_id — BIGINT — Foreign key → product.id — NOT NULL
- url — VARCHAR(255) — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
qna
- id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- answer — TEXT
- answered — BOOLEAN — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME