ISWM

Tables (3)

islands

  • island_no — BIGINT
  • island_id — CHAR(36) — NOT NULL
  • island_name — VARCHAR(255)
  • x — DOUBLE — NOT NULL
  • y — DOUBLE — NOT NULL
  • z — DOUBLE — NOT NULL
  • team_no — BIGINT — Foreign key → teams.team_no
  • created_at — TIMESTAMP

teams

  • team_no — BIGINT
  • team_id — CHAR(36) — NOT NULL
  • team_name — VARCHAR(255) — NOT NULL
  • owner_no — BIGINT — Foreign key → users.user_no — NOT NULL
  • created_at — TIMESTAMP

users

  • user_no — BIGINT
  • uuid — CHAR(36) — NOT NULL
  • username — VARCHAR(16) — NOT NULL
  • nickname — VARCHAR(255)
  • team_no — BIGINT — Foreign key → teams.team_no
  • balance — BIGINT
  • created_at — TIMESTAMP
  • last_played — TIMESTAMP