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