벼리 erd 설계
테이블 (10)
HomeWidget
- widget_id — INT
- user_id — INT
- parent_id — INT
- widget_type — VARCHAR(50) — NOT NULL
- grid_x — INT
- grid_y — INT
- width — INT
- height — INT
- content_json — LONGTEXT
- style_json — TEXT
- is_locked — BOOLEAN
Post
- post_id — INT
- user_id — INT
- title — VARCHAR(255) — NOT NULL
- content — LONGTEXT
- is_public — BOOLEAN
- view_count — INT
- created_at — DATETIME
PostTag
- post_id — INT
- tag_id — INT
SocialAccount
- social_id — INT
- user_id — INT — NOT NULL
- provider — VARCHAR(50) — NOT NULL
- provider_user_id — VARCHAR(255) — NOT NULL
- access_token — TEXT
- refresh_token — TEXT
- connected_at — DATETIME
Tag
- tag_id — INT
- name — VARCHAR(50) — NOT NULL
Todo
- todo_id — INT
- user_id — INT
- title — VARCHAR(255) — NOT NULL
- completed — BOOLEAN
- start_date — DATE
User
- user_id — INT
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255)
- nickname — VARCHAR(50)
- profile_image_url — TEXT
- bio — TEXT
- status_message — VARCHAR(255)
- birth_date — DATE
- gender — VARCHAR(10)
- phone_number — VARCHAR(20)
- is_social_only — BOOLEAN
- created_at — DATETIME
- updated_at — DATETIME
UserInventory
- inventory_id — INT
- user_id — INT
- asset_id — INT
- purchased_at — DATETIME
UserSetting
- setting_id — INT
- user_id — INT
- theme_mode — VARCHAR(20)
- primary_color — VARCHAR(10)
- font_family — VARCHAR(50)
- custom_css — LONGTEXT
- language — VARCHAR(10)
Wallet
- user_id — INT
- cash_balance — DECIMAL(15,2)
- reward_points — INT