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