test

Tables (8)

Comment (Untitled8)

  • id — int — Primary key — NOT NULL
  • Key (id2) — int — Foreign key → Member.Key — NOT NULL
  • post_id — int
  • member_id — int
  • content — text
  • createdAt — datetime

Member (Untitled)

  • Key (id) — int — Primary key — NOT NULL
  • Name — nvarchar(20)
  • Phone — char(14)
  • Email — varchar(30)
  • Address — varchar(50)

Order (Untitled2)

  • id — int — Primary key — NOT NULL
  • Key (id2) — int — Foreign key → Member.Key — NOT NULL
  • member_id — int
  • order_date — datetime

OrderDatail (Untitled5)

  • id — int — Primary key — NOT NULL
  • id (id2) — int — Foreign key → Order.id — NOT NULL
  • Key (id22) — int — Foreign key → Order.Key — NOT NULL
  • id (id3) — int — Foreign key → Product.id — NOT NULL
  • key (order_id) — int
  • key (product_id) — int
  • quantity — int
  • delivery_address (delevery_address) — varchar(50)

Post (Untitled7)

  • id — int — Primary key — NOT NULL
  • Key (id2) — int — Foreign key → Member.Key — NOT NULL
  • member_id — int
  • title — nvarchar(50)
  • content — text
  • createdAt (createAt) — datetime

Product (Untitled3)

  • id — int — Primary key — NOT NULL
  • name — nvarchar(100)
  • stock — int
  • unit_price — decimal(10,2)

Supplier (Untitled4)

  • id — int — Primary key — NOT NULL
  • name — nvarchar(100)
  • phone — char(14)
  • contact_person — nvarchar(50)
  • address — varchar(50)

Supply (Untitled6)

  • id — int — Primary key — NOT NULL
  • id (id2) — int — Foreign key → Product.id — NOT NULL
  • key (id3) — int — Foreign key → Supplier.id — NOT NULL
  • key (product_id) — int
  • key (supplier_id) — int
  • supply_date — datetime
  • quantity — int