Black Pearl
Tables (5)
Comment (C3)
- commentid (Key) — int — Primary key — NOT NULL
- productid (Key2) — int — Foreign key → Product.productid — NOT NULL
- userid (Key22) — int — Foreign key → Product.likeuser — NOT NULL
- comment (Field) — string
Company (C2)
- companyid (Key) — int — Primary key — NOT NULL
- userid (Key2) — int — Foreign key → User.userid — NOT NULL
- productid (Key3) — int — Foreign key → Product.productid — NOT NULL
- 사양 (Field) — dict
- score (Field2) — int
- companyname (Field4) — string
Product (C)
- productid (Key) — int — Primary key — NOT NULL
- likeuser (Key2) — int — Foreign key → User.userid — NOT NULL
- sawuser (Key22) — int — Foreign key → User.sawproduct — NOT NULL
- 사양 (Field) — dict
- score (Field2) — int
- image (Field3) — string
- productname (.) — string
Request (Untitled2)
- requestid (Key) — int — Primary key — NOT NULL
- userid (Key2) — int — Foreign key → User.userid — NOT NULL
- productid (Key22) — int — Foreign key → User.sawproduct — NOT NULL
- likeuser (Key222) — int — Foreign key → User.likeproduct — NOT NULL
- date (Field) — date
- request (Field2) — bool
- permission (Field3) — bool
- 내용 (Field4) — dict
User (Untitled)
- userid (Key) — int — Primary key — NOT NULL
- sawproduct (Key2) — int — Foreign key → Product.productid — NOT NULL
- likeproduct (Key22) — int — Foreign key → Product.likeuser — NOT NULL
- company (Field) — dict
- admin (Field2) — bool
- password (Field3) — string
- username (Field4) — string
- email (Field5) — string