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)