jaeyeonShop
Tables (7)
Board (board)
- Key — INT — Primary key — NOT NULL
- Key (Key2) — INT — Foreign key → User.Key — NOT NULL
- Field — VARCHAR(255)
- Field2 — VARCHAR(45)
- Field3 — INT
Cart (cart)
- Key — INT — Primary key — NOT NULL
- Key (Key2) — INT — Foreign key → User.Key — NOT NULL
- Key (Key3) — INT — Foreign key → Product.Key — NOT NULL
- Key (Key4) — INT — Foreign key → ProductOrder.Key — NOT NULL
- Field4 — INT
Comment (Untitled)
- Key — INT — Primary key — NOT NULL
- Key (Key2) — INT — Foreign key → User.Key — NOT NULL
- Field — INT
- Field3 — INT
- Field2 — VARCHAR(255)
Product (product)
- Key — INT — Primary key — NOT NULL
- Field — VARCHAR(45)
- Field2 — INT
- Field3 — VARCHAR(45)
- Field4 — VARCHAR(255)
- Field5 — VARCHAR(255)
- Field6 — VARCHAR(45)
- Field7 — INT
- Field8 — INT
- Field9 — INT
ProductImg (product_img)
- Key — INT — Primary key — NOT NULL
- Key (Key2) — INT — Foreign key → Product.Key — NOT NULL
- Field — VARCHAR(255)
- Field2 — VARCHAR(255)
- Field3 — VARCHAR(255)
- Field4 — BIGINT
ProductOrder (product_order)
- Key — INT — Primary key — NOT NULL
- Key (Key2) — INT — Foreign key → User.Key — NOT NULL
- Field — VARCHAR(45)
- Field2 — INT
- Field3 — INT
User (user)
- Key — int — Primary key — NOT NULL
- Field — VARCHAR(45)
- Field2 — VARCHAR(45)
- Field3 — VARCHAR(45)
- Field4 — VARCHAR(45)
- Field5 — VARCHAR(45)
- Field6 — VARCHAR(45)
- Field7 — VARCHAR(45)