ygo
Tables (5)
CATEGORY
- CID — Primary key — NOT NULL
- CATEGORY_NAME
DECK
- DID — Primary key — NOT NULL
- CID — Foreign key → CATEGORY.CID — NOT NULL
- UUID — BIGINT — Foreign key → USERINFO.UUID — NOT NULL
- DECK_NAME
FIGHT_LOG
- FID — Primary key — NOT NULL
- WIN_DID
- LOSS_DID
- DATE
- CID — Foreign key → DECK.CID — NOT NULL
- UUID — BIGINT — Foreign key → DECK.UUID — NOT NULL
PROFILE
- UUID — BIGINT — Foreign key → USERINFO.UUID — NOT NULL
- NICKNAME — VARCHAR(255)
USERINFO
- UUID — BIGINT — Primary key — NOT NULL
- ID — VARCHAR(255)
- PW — VARCHAR(255)