prospecs

Tables (6)

Company (Untitled3)

  • cid (Key) — Primary key — NOT NULL
  • pw (Field)
  • name (Field2)

ORDER_TYPE (Untitled6)

  • 결제완료 (Field)
  • Field2

Order (Untitled5)

  • oid (Key) — Primary key — NOT NULL
  • order_date (Field)

Product (Untitled2)

  • pid (Key) — Primary key — NOT NULL
  • cid (Key2) — Foreign key → Company.cid — NOT NULL
  • p_name (Field2)
  • price (Field3)
  • stock (Field4)

User (Untitled)

  • uid (user) — Primary key — NOT NULL
  • pw (Field)
  • name (Field2)

img (Untitled4)

  • img_src (Key) — Primary key — NOT NULL