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)