dbfinalproject

Tables (6)

CENTER (Untitled3)

  • name (Key) — varchar(128) — Primary key — NOT NULL
  • location (Field) — varchar(128)
  • opentime (Field2) — varchar(128)
  • closetime (Field3) — varchar(128)
  • dayoff (Field4) — varchar(128)

COMMENT (Untitled5)

  • username (Key2) — varchar(128) — Foreign key → POST.username — NOT NULL
  • post (Field) — varchar(128)
  • answer (Field2) — varchar(128)

ORDER (Untitled)

  • order_id (Key) — integer — Primary key — NOT NULL
  • username (Key2) — varchar(128) — Foreign key → USER.username — NOT NULL
  • productname (Key3) — varchar(128) — Foreign key → PRODUCT.productname — NOT NULL
  • name (Key4) — varchar(128) — Foreign key → CENTER.name — NOT NULL
  • orderdate (Field) — varchar(128)
  • problem (Field4) — varchar(128)

POST (Untitled4)

  • username (Key2) — varchar(128) — Foreign key → USER.username — NOT NULL
  • question (Field) — varchar(128)
  • postdate (Field2) — datefield

PRODUCT (Untitled2)

  • productname (Key) — varchar(128) — Primary key — NOT NULL
  • category (Field) — varchar(128)
  • price (Field2) — integer

USER (User)

  • username (Key) — varchar(128) — Primary key — NOT NULL
  • phone (Field) — integer
  • address (Field2) — varchar(128)