Mini Project Test

Tables (4)

Character

  • characterId — long — Primary key — NOT NULL
  • characterName — string
  • height — int
  • age — int
  • gender — string
  • personality — string
  • characterSetting — string
  • createDate — datetime
  • userId — long — Foreign key → User.userId — NOT NULL

CharacterKeyword

  • KeywordMachId — long — Primary key — NOT NULL
  • characterId — long — Foreign key → Character.characterId — NOT NULL
  • keywordId — long — Foreign key → Keyword.keywordId — NOT NULL

Keyword

  • keywordId — long — Primary key — NOT NULL
  • keywordName — string

User

  • userId — long — Primary key — NOT NULL
  • name — string
  • email — string
  • password — string
  • nicname — string
  • signupDate — datetime