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)