cotest
Tables (10)
address
- id (address_id) — BIGINT — Primary key — NOT NULL
- address — VARCHAR(255)
- city — VARCHAR(255)
- zipcode — VARCHAR(255)
cart (Untitled)
- Key — Primary key — NOT NULL
- id (client_id) — BIGINT — Foreign key → client.id
- id (product_id) — BIGINT — Foreign key → product.id — NOT NULL
- Field (quantity)
category
- id (category_id) — BIGINT — Primary key — NOT NULL
- id (product_id) — BIGINT — Foreign key → product.id — NOT NULL
- name — VARCHAR(255)
client
- id (client_id) — BIGINT — Primary key
- id (address_id) — BIGINT — Foreign key → address.id — NOT NULL
- id (job_id) — BIGINT — Foreign key → job.id — NOT NULL
- name — VARCHAR(20)
- phone — VARCHAR(14)
- birthday — VARCHAR(10)
company
- id (company_id) — BIGINT — Primary key — NOT NULL
- id (address_id) — BIGINT — Foreign key → address.id — NOT NULL
- name — VARCHAR(255)
- phone — VARCHAR(255)
- homepage — VARCHAR(255)
- email — VARCHAR(255)
employee
- id (employee_id) — BIGINT — Primary key — NOT NULL
- id (company_id) — BIGINT — Foreign key → company.id — NOT NULL
- name — VARCHAR(255)
- gender — VARCHAR(6)
- team — VARCHAR(255)
- join_at — DATETIME(6)
job
- id (job_id) — BIGINT — Primary key — NOT NULL
- name (Field) — VARCHAR(255)
- type (Field2) — VARCHAR(255)
order
- id (order_id) — BIGINT — Primary key — NOT NULL
- id (client_id) — BIGINT — Foreign key → client.id — NOT NULL
- totalPrice (quantity) — BIGINT
- created_at — DATETIME(6)
orderItems (Untitled2)
- Key — Primary key — NOT NULL
- id (order_id) — BIGINT — Foreign key → order.id — NOT NULL
- id (product_id) — BIGINT — Foreign key → product.id — NOT NULL
- totalPrice (Field)
product
- id (product_id) — BIGINT — Primary key — NOT NULL
- id (company_id) — BIGINT — Foreign key → company.id — NOT NULL
- name — VARCHAR(255)
- content — LONGTEXT
- price — DECIMAL
- supply_price — DECIMAL
- created_at — DATETIME(6)
- expired_at — DATETIME(6)