20241212
Tables (8)
Bulletin Board (Untitled6)
- B_id (Key) — char(8) — Primary key — NOT NULL
- Title (Field) — varchar(30)
- Contents (Field2) — varchar(30)
- writer (Field3) — varchar(30)
- date_time (Field4) — varchar(30)
- M_id (Key2) — char(8) — Foreign key → Member.M_id — NOT NULL
Comments (Untitled7)
- C_id (Key) — char(8) — Primary key — NOT NULL
- Title (Field) — varchar(30)
- Contents (Field2) — varchar(30)
- writer (Field3) — varchar(30)
- date_time (Field4) — varchar(30)
- B_id (Key2) — char(8) — Foreign key → Bulletin Board.B_id — NOT NULL
- M_id (Key3) — char(8) — Foreign key → Member.M_id — NOT NULL
Comments Of Comments (CopyOfUntitled7)
- CC_id (Key) — char(8) — Primary key — NOT NULL
- Title (Field) — varchar(30)
- Contents (Field2) — varchar(30)
- writer (Field3) — varchar(30)
- date_time (Field4) — varchar(30)
- C_id (Key2) — char(8) — Foreign key → Comments.C_id — NOT NULL
- M_id (Key3) — char(8) — Foreign key → Member.M_id — NOT NULL
Member (Untitled)
- M_id (Key) — char(8) — Primary key — NOT NULL
- _Name (Field) — varchar(30)
- Phone number (Field2) — char(13)
- email (Field3) — varchar(30)
- address (Field4) — varchar(30)
Order (Untitled3)
- M_id (Key2) — char(8) — Foreign key → Member.M_id — NOT NULL
- SP_id (Key3) — char(8) — Foreign key → Sale_Product.SP_id — NOT NULL
- Quantity (Field) — char(8)
- address (Field2) — varchar(30)
- date (Field3) — varchar(30)
Sale_Product (Untitled2)
- SP_id (Key) — char(8) — Primary key — NOT NULL
- Product_Name (Field) — varchar(30)
- Inventory (Field2) — char(8)
- Unitprice (Field3) — char(8)
Supplier (Untitled4)
- S_id (Key) — char(8) — Primary key — NOT NULL
- _Name (Field) — varchar(30)
- Phone number (Field2) — char(13)
- Representative_Name (Field3) — varchar(30)
- address (Field4) — varchar(30)
- Field5
Supply_Feed_Product (Untitled5)
- S_id (Key) — char(8) — Foreign key → Supplier.S_id — NOT NULL
- SP_id (Key2) — char(8) — Foreign key → Sale_Product.SP_id — NOT NULL
- date (Field) — varchar(8)
- quatity (Field2) — char(8)