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)