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