tanscendence
Tables (9)
Achievement
- achievement_id — Long — Primary key — NOT NULL
- Name (name) — String
- Icon (icon) — String
- description
Channel (channel)
- channel_id — Long — Primary key — NOT NULL
- title (Field) — String
- mode — ENUM
- total — Long
- password — String
ChannelMember
- user_id — Long — Foreign key → User.user_id — NOT NULL
- channel_id — Long — Foreign key → Channel.channel_id — NOT NULL
- role (Owner, Staff, Member)
Chats
- chat_id — Long — Primary key — NOT NULL
- content — string
- user_id — Long — Foreign key → User.user_id — NOT NULL
- channel_id — Long — Foreign key → Channel.channel_id — NOT NULL
- date — LocaldateTime
Game
- game_id — Long — Primary key — NOT NULL
- date — LocaldateTime
- user_id1 — Long — Foreign key → User.user_id — NOT NULL
- user_id2 (user_id22) — Long — Foreign key → User.user_id — NOT NULL
- winner_id — Long
- type — Enum
- mode — Enum
Relationship (Relation)
- user_id1 — Long — Foreign key → User.user_id — NOT NULL
- user_id2 — Long — Foreign key → User.user_id — NOT NULL
- relationship — Enum
User
- user_id — Long — Primary key — NOT NULL
- nickNmae (nick_name) — Varchar(8)
- isSecond (is_second) — boolean
- gameList (Field) — List
- relationList — List
- avatar — String
- point — Long
UserAchievement
- user_id — Long — Foreign key → User.user_id — NOT NULL
- achievement_id — Long — Foreign key → Achievement.achievement_id — NOT NULL
- date — LocalDateTime