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