CheckList

Tables (8)

Character

  • Key (character_id) — Long — Primary key — NOT NULL
  • 사용자 식별 id (member_id) — Long — Foreign key → Member.사용자 식별 id — NOT NULL
  • Field (name) — String — NOT NULL
  • Field2 (level) — int
  • Field3 (world) — String
  • Field4 (job) — String
  • Field (ocid) — String — NOT NULL

Copy Of Copy Of Untitled2 (Common)

  • Key (common_id) — Long — Primary key — NOT NULL
  • Key (character_id) — Long — Foreign key → Character.Key — NOT NULL
  • Field (content) — String
  • Field2 (is_completed) — boolean — NOT NULL
  • Field (type) — TYPE — NOT NULL

Copy Of Untitled (Weekly)

  • Key (weekly_id) — Long — Primary key — NOT NULL
  • Key (character_id) — Long — Foreign key → Character.Key — NOT NULL
  • Field (content) — String
  • Field2 (is_completed) — boolean — NOT NULL

Copy Of Untitled2 (Monthly)

  • Key (monthly_id) — Long — Primary key — NOT NULL
  • Key (character_id) — Long — Foreign key → Character.Key — NOT NULL
  • Field (content) — String
  • Field2 (is_completed) — boolean — NOT NULL

Member (Member)

  • 사용자 식별 id (member_id) — Long — Primary key — NOT NULL
  • 이메일 (email) — String — NOT NULL
  • 비밀번호 (password) — String — NOT NULL
  • Field (role) — String — NOT NULL

Untitled (Daily)

  • Key (daily_id) — Long — Primary key — NOT NULL
  • Key (character_id) — Long — Foreign key → Character.Key — NOT NULL
  • Field (content) — String
  • Field2 (is_completed) — boolean — NOT NULL

Untitled2 (Achievement)

  • Key (archievement_id) — Long — Primary key — NOT NULL
  • Key (character_id) — Long — Foreign key → Character.Key — NOT NULL
  • Field (daily) — double — NOT NULL
  • Field2 (weekly) — double — NOT NULL
  • Field3 (monthly) — double — NOT NULL

common (Untitled)

  • is_deleted — boolean — NOT NULL
  • updated_at — date — NOT NULL
  • created_at — date — NOT NULL