308G
Tables (5)
ACCOUNT
- Id — VARCHAR(255) — Primary key — NOT NULL
- Password — VARCHAR(255)
- Username — VARCHAR(255)
- Firstname — VARCHAR(255)
- Birthday — CHAR(8)
- Gender — CHAR(1)
- Phone — CHAR(11)
- Email — VARCHAR(100)
BODY
- Bodykey — INT — Primary key — NOT NULL — AUTO_INCREMENT
- Id — VARCHAR(255) — Foreign key → ACCOUNT.Id — NOT NULL
- Checkday — CHAR(8)
- Height — INT(3)
- Weight — INT(4)
- Upper — FLOAT(4)
- Shoulder — FLOAT(4)
- Arm — FLOAT(4)
- Waist — CHAR(3)
- Leg — FLOAT(4)
MAN
- Id — VARCHAR(255) — Foreign key → BODY.Id — NOT NULL
- Key — Foreign key → BODY.Bodykey — NOT NULL
- Chest — CHAR(2)
- Tummy — CHAR(2)
PREFERENCE
- Preferencekey — INT(100) — Primary key — NOT NULL — AUTO_INCREMENT
- Id — VARCHAR(255) — Foreign key → ACCOUNT.Id — NOT NULL
- Fit — VARCHAR(100)
- Brand — VARCHAR(100)
- Vibe — VARCHAR(100)
- Type — VARCHAR(100)
- Esg — VARCHAR(100)
WOMN (WOMAN)
- Id — VARCHAR(255) — Foreign key → BODY.Id — NOT NULL
- Key — Foreign key → BODY.Bodykey — NOT NULL
- Bra_size — INT(3)
- Bra_cup — CHAR(2)
- Hip — CHAR(2)
- Tummy — CHAR(2)