Game Application
Tables (11)
Game (game)
- gameId (id) — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100)
- imageUrl (image_url) — VARCHAR(500)
- active — BOOLEAN
- createdAt (created_at) — DATETIME
- updatedAt (updated_at) — DATETIME
GameRole (game_role)
- gameRoleId (id) — BIGINT — Primary key — NOT NULL
- gameId (game_id) — BIGINT — Foreign key → Game.gameId — NOT NULL
- name — VARCHAR(100)
- roleType (role_type) — VARCHAR(30)
- active — BOOLEAN
GameServer (game_server)
- gameServerId (id) — BIGINT — Primary key — NOT NULL
- gameId (game_id) — BIGINT — Foreign key → Game.gameId — NOT NULL
- name — VARCHAR(100)
- active — BOOLEAN
Guild (guild)
- guildId (id) — BIGINT — Primary key — NOT NULL
- masterId (master_id) — BIGINT — Foreign key → Member.memberId — NOT NULL
- gameId (game_id) — BIGINT — Foreign key → Game.gameId — NOT NULL
- gameServerId (game_server_id) — BIGINT — Foreign key → GameServer.gameServerId — NOT NULL
- name — VARCHAR(100)
- description — TEXT
- maxMembers (max_members) — INT
- status — VARCHAR(30)
- createdAt (created_at) — DATETIME
- updatedAt (updated_at) — DATETIME
GuildApplication (guild_application)
- guildApplicationId (id) — BIGINT — Primary key — NOT NULL
- guildId (guild_id) — BIGINT — Foreign key → Guild.guildId — NOT NULL
- memberId (member_id) — BIGINT — Foreign key → Member.memberId — NOT NULL
- status — VARCHAR(30)
- message — VARCHAR(500)
- appliedAt (applied_at) — DATETIME
- processedAt (processed_at) — DATETIME
GuildMember (guild_member)
- guildMemberId (id) — BIGINT — Primary key — NOT NULL
- guildId (guild_id) — BIGINT — Foreign key → Guild.guildId — NOT NULL
- memberId (member_id) — BIGINT — Foreign key → Member.memberId — NOT NULL
- guildRole (guild_role) — VARCHAR(30)
- joinedAt (joined_at) — DATETIME
Member (member)
- memberId (id) — BIGINT — Primary key — NOT NULL
- email — VARCHAR(100)
- password — VARCHAR(255)
- nickname — VARCHAR(50)
- role — VARCHAR(20)
- status — VARCHAR(20)
- createdAt (created_at) — DATETIME
- updatedAt (updated_at) — DATETIME
Party (party)
- partyId (id) — BIGINT — Primary key — NOT NULL
- leaderId (leader_id) — BIGINT — Foreign key → Member.memberId — NOT NULL
- gameId (game_id) — BIGINT — Foreign key → Game.gameId — NOT NULL
- gameServerId (game_server_id) — BIGINT — Foreign key → GameServer.gameServerId — NOT NULL
- requiredRoleId (required_role_id) — BIGINT — Foreign key → GameRole.gameRoleId — NOT NULL
- title — VARCHAR(150)
- content — TEXT
- maxMembers (max_members) — INT
- status — VARCHAR(30)
- playAt (play_at) — DATETIME
- createdAt (created_at) — DATETIME
- updatedAt (updated_at) — DATETIME
PartyApplication (party_application)
- partyApplicationId (id) — BIGINT — Primary key — NOT NULL
- partyId (party_id) — BIGINT — Foreign key → Party.partyId — NOT NULL
- memberId (member_id) — BIGINT — Foreign key → Member.memberId — NOT NULL
- gameRoleId (game_role_id) — BIGINT — Foreign key → GameRole.gameRoleId — NOT NULL
- status — VARCHAR(30)
- message — VARCHAR(500)
- appliedAt (applied_at) — DATETIME
- processedAt (processed_at) — DATETIME
PartyMember (party_member)
- partyMemberId (id) — BIGINT — Primary key — NOT NULL
- partyId (party_id) — BIGINT — Foreign key → Party.partyId — NOT NULL
- memberId (member_id) — BIGINT — Foreign key → Member.memberId — NOT NULL
- memberRole (member_role) — VARCHAR(30)
- joinedAt (joined_at) — DATETIME
- Field
Report (report)
- reportId (id) — BIGINT — Primary key — NOT NULL
- reporterId (reporter_id) — BIGINT — Foreign key → Member.memberId — NOT NULL
- targetType (target_type) — VARCHAR(30)
- targetId (target_id) — BIGINT
- reason — VARCHAR(100)
- content — TEXT
- status — VARCHAR(30)
- createdAt (created_at) — DATETIME
- processedAt (processed_at) — DATETIME
- Field