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