MobiParty
Tables (5)
application
- id — BIGINT — Primary key — NOT NULL — PK
- member_id — BIGINT — Foreign key → member.id — NOT NULL — FK
- post_id — BIGINT — Foreign key → post.id — NOT NULL — FK
- status — VARCHAR(20) — NOT NULL
- version — BIGINT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
member
- id — BIGINT — Primary key — NOT NULL — PK
- username — VARCHAR(20) — NOT NULL
- password — VARCHAR(255)
- nickname — VARCHAR(12) — NOT NULL
- role — VARCHAR(10) — NOT NULL
- provider — VARCHAR(10) — NOT NULL
- server — VARCHAR(10) — NOT NULL
- game_nickname — VARCHAR(12) — NOT NULL
- job — VARCHAR(10) — NOT NULL
- combat_power — INT UNSIGNED — NOT NULL
- magic_resistance — INT UNSIGNED — NOT NULL
- intro — VARCHAR(100)
- created_at — DATETIME — NOT NULL
- updated_at — NOT NULL
notification
- id — BIGINT — Primary key — NOT NULL — PK
- member_id — BIGINT — Foreign key → member.id — NOT NULL — FK
- post_id — BIGINT — Foreign key → post.id — NOT NULL — FK
- type — VARCHAR(30) — NOT NULL
- content — VARCHAR(100) — NOT NULL
- is_read — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
post
- id — BIGINT — Primary key — NOT NULL — PK
- member_id — BIGINT — Foreign key → member.id — NOT NULL — FK
- title — VARCHAR(50) — NOT NULL
- content — VARCHAR(500)
- recruit_count — TINYINT UNSIGNED — NOT NULL
- status — VARCHAR(20) — NOT NULL
- image_url — VARCHAR(500)
- closed_at — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
refresh_token
- id — BIGINT — Primary key — NOT NULL — PK
- member_id — BIGINT — Foreign key → member.id — NOT NULL — FK
- token_value — CHAR(64) — NOT NULL
- expired_at — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL