몽키트레이더스
테이블 (19)
Accounts
- id — UUID
- user_id — UUID — NOT NULL
- balance — DECIMAL(20, 2)
- can_reset_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ
- updated_at — TIMESTAMPTZ
Assets
- id — SERIAL
- asset_type — asset_type_enum — NOT NULL
- item_code — VARCHAR(50) — NOT NULL
- item_name — VARCHAR(255) — NOT NULL
- market — VARCHAR(100)
- sector — VARCHAR(100)
- country — VARCHAR(100)
- currency — VARCHAR(10)
- symbol — VARCHAR(20)
- exchange — VARCHAR(100)
- is_active — BOOLEAN
- created_at — TIMESTAMPTZ
- updated_at — TIMESTAMPTZ
Coins
- coin_id — SERIAL
- item_code — VARCHAR(50) — NOT NULL
- item_name — VARCHAR(255) — NOT NULL
- symbol — VARCHAR(20)
- base_currency — VARCHAR(10)
- exchange — VARCHAR(100)
- created_at — TIMESTAMPTZ
- updated_at — TIMESTAMPTZ
- deleted_at — TIMESTAMPTZ
Holdings
- id — UUID
- user_id — UUID — NOT NULL
- item_code — VARCHAR(50) — NOT NULL
- item_name — VARCHAR(255) — NOT NULL
- quantity — DECIMAL(20, 6) — NOT NULL
- avg_price — DECIMAL(20, 2) — NOT NULL
- last_updated_at — TIMESTAMPTZ
- fee — DECIMAL(20, 2)
- latest_exchange_rate — DECIMAL(20, 6)
- latest_price — DECIMAL(20, 2)
InfluencerAccounts
- id — SERIAL
- person_id — INTEGER — NOT NULL
- platform_id — INTEGER — NOT NULL
- handle — VARCHAR(100) — NOT NULL
- url — VARCHAR(2048)
- created_at — TIMESTAMPTZ
InfluencerKeywords
- id — SERIAL
- person_id — INTEGER — NOT NULL
- keyword — VARCHAR(100) — NOT NULL
- created_at — TIMESTAMPTZ
Influencers
- person_id — SERIAL
- name — VARCHAR(255) — NOT NULL
- profile_image_url — VARCHAR(2048)
- description — TEXT
- created_at — TIMESTAMPTZ
- updated_at — TIMESTAMPTZ
- deleted_at — TIMESTAMPTZ
NewsArticles
- article_id — SERIAL
- title — VARCHAR(500) — NOT NULL
- content — TEXT — NOT NULL
- source — VARCHAR(100)
- url — VARCHAR(2048) — NOT NULL
- published_at — TIMESTAMPTZ
- view_count — INTEGER
- author_name — VARCHAR(255)
- category — VARCHAR(100)
- created_at — TIMESTAMPTZ
- updated_at — TIMESTAMPTZ
- deleted_at — TIMESTAMPTZ
NewsKeywords
- id — SERIAL
- news_id — INTEGER — NOT NULL
- keyword — VARCHAR(100) — NOT NULL
- created_at — TIMESTAMPTZ
Oauth
- id — UUID
- user_id — UUID — NOT NULL
- provider — VARCHAR(50) — NOT NULL
- provider_id — VARCHAR(255) — NOT NULL
- refresh_token — TEXT
- expires_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ
PersonNewsMappings
- id — SERIAL
- person_id — INTEGER — NOT NULL
- article_id — INTEGER — NOT NULL
- relation_type — VARCHAR(20)
- score — NUMERIC(3, 2)
- created_at — TIMESTAMPTZ
- UNIQUE(person_id, — article_id)
Platforms
- id — SERIAL
- code — VARCHAR(50) — NOT NULL
- name_ko — VARCHAR(50) — NOT NULL
- name_en — VARCHAR(50) — NOT NULL
PostImages
- id — UUID
- post_id — UUID — NOT NULL
- image_url — TEXT — NOT NULL
- original_name — VARCHAR(255)
- file_size — BIGINT
- mime_type — VARCHAR(100)
- created_at — TIMESTAMPTZ
PostLikes
- id — UUID
- post_id — UUID — NOT NULL
- user_id — UUID — NOT NULL
- created_at — TIMESTAMPTZ
Posts
- id — UUID
- user_id — UUID — NOT NULL
- target_type — post_target_type_enum — NOT NULL
- target_id — VARCHAR(50) — NOT NULL
- content — TEXT — NOT NULL
- like_count — INT
- created_at — TIMESTAMPTZ
- updated_at — TIMESTAMPTZ
- deleted_at — TIMESTAMPTZ
SocialPosts
- id — BIGINT
- person_id — INTEGER — NOT NULL
- platform_id — INTEGER — NOT NULL
- content — TEXT — NOT NULL
- posted_at — TIMESTAMPTZ
- url — VARCHAR(2048)
- created_at — TIMESTAMPTZ
- updated_at — TIMESTAMPTZ
- deleted_at — TIMESTAMPTZ
Stocks
- stock_id — SERIAL
- item_code — VARCHAR(50) — NOT NULL
- item_name — VARCHAR(255) — NOT NULL
- market — VARCHAR(100)
- currency — VARCHAR(10)
- sector — VARCHAR(100)
- country — VARCHAR(100)
- created_at — TIMESTAMPTZ
- updated_at — TIMESTAMPTZ
- deleted_at — TIMESTAMPTZ
Transactions
- id — UUID
- user_id — UUID — NOT NULL
- trade_type — trade_type_enum — NOT NULL
- asset_type — asset_type_enum — NOT NULL
- item_code — VARCHAR(50) — NOT NULL
- amount — DECIMAL(20, 6) — NOT NULL
- price — DECIMAL(20, 2) — NOT NULL
- fee — DECIMAL(20, 2)
- exchange_rate — DECIMAL(20, 6)
- created_at — TIMESTAMPTZ
Users
- id — UUID
- name — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- last_login_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ
- updated_at — TIMESTAMPTZ
- deleted_at — TIMESTAMPTZ