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