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