PEER

Tables (8)

APPLIED_ROOM_ITEMS

  • item_slot_id — VARCHAR(20)
  • uid — VARCHAR(128) — Foreign key → USERS.uid
  • prefabItemId — VARCHAR(200)
  • appliedMaterials — TEXT

DIARIES

  • diary_id — VARCHAR(20) — Primary key — NOT NULL
  • uid — VARCHAR(220) — Foreign key → USERS.uid
  • content — TEXT
  • date — VARCHAR(50)
  • emotion — VARCHAR(50)
  • fontID — VARCHAR(50)
  • paperID — VARCHAR(50)
  • textObjects — TEXT

HELPS_BOARD

  • id — VARCHAR(20) — Primary key — NOT NULL
  • title — VARCHAR(100)
  • content — TEXT
  • date — VARCHAR(20)
  • IconType — INT

NOTICE_BOARD

  • id — VARCHAR(20) — Primary key — NOT NULL
  • title — VARCHAR(500)
  • content — TEXT
  • date — VARCHAR(20)
  • IconType — INT

QUEST_PROGRESS

  • uid — VARCHAR(128) — Foreign key → USERS.uid — NOT NULL
  • AllClear — INT
  • Attendance — INT
  • AvatarEdit — INT
  • Music — INT
  • RoomEdit — INT
  • WriteDiary — INT

SELECTED_PRESENT

  • diary_id — VARCHAR(20) — Foreign key → DIARIES.diary_id — NOT NULL
  • present_id — VARCHAR(20)
  • name — VARCHAR(100)
  • description — TEXT
  • tags — TEXT

TEXT_OBJECTS

  • diary_id — VARCHAR(20) — Foreign key → DIARIES.diary_id
  • pos_x — FLOAT
  • pos_y — FLOAT
  • width — FLOAT
  • height — FLOAT
  • rotation — FLOAT
  • scale — FLOAT
  • color_hex — VARCHAR(9)
  • text — TEXT
  • font_style — INT
  • alignment — INT

USERS

  • uid — VARCHAR(128) — Primary key — NOT NULL
  • email — VARCHAR(100)
  • nickname — VARCHAR(20)
  • birthDate — VARCHAR(20)
  • createdAt — BIGINT
  • profileImage — TEXT
  • currency — INT
  • dailyAdCount — INT
  • bgmSetting — BOOLEAN
  • isSetupComplete — BOOLEAN
  • lastAddDate — VARCHAR(20)
  • lastFlowerSelectDate — VARCHAR(20)
  • lastQuestDate — VARCHAR(20)
  • avatarIdx_0 — INT
  • avatarIdx_1 — INT
  • avatarIdx_2 — INT
  • avatarIdx_3 — INT