test

Tables (4)

Brand (Untitled3)

  • Key (BrnadId) — BIGINT — Primary key — NOT NULL
  • Field (name) — varchar(20)
  • Field2 (Iamge) — varchar(200)
  • Field3 (address) — varchar(200)
  • Field (createdAt) — TIMESTAMP
  • Field

Clothes (Untitled2)

  • Key (clothId) — BIGINT — Primary key — NOT NULL
  • Field (categoty) — varchar(10)
  • Field2 (price) — int
  • Field3 (size) — char(2)
  • Field (Image) — varchar(200)
  • Field (Info) — TEXT
  • Key (BrnadId) — BIGINT — Foreign key → Brand.Key — NOT NULL

History (Untitled4)

  • Key (buyId) — BIGINT — Primary key — NOT NULL
  • Key (clothId) — BIGINT — Foreign key → Clothes.Key — NOT NULL
  • Key (userId) — BIGINT — Foreign key → User.Key — NOT NULL

User (Untitled)

  • Key (userId) — BIGINT — Primary key — NOT NULL
  • Field (ID) — varchar(20)
  • Field2 (PW) — varchar(200)
  • Field3 (Sex) — char(1)
  • Field (Size) — char(2)
  • Email — varchar(20)
  • Field (ProfileImage) — varchar(200)
  • Field (grade) — varchar(10)
  • Field (createdAt) — TIMESTAMP
  • Field2 (updatedAt) — TIMESTAMP
  • Field3 (status) — TINYINT