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