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