Z맘대로
테이블 (43)
account
- id — int8 — 기본 키 — NOT NULL
- account_name — varchar(255)
- account_no — varchar(255) — NOT NULL
- account_type — varchar(255) — NOT NULL
- account_type_unique_no — varchar(255)
- bank_code — varchar(255)
- created_at — varchar(255)
- currency — varchar(255)
- user_key — varchar(255)
- account_pin_hash — varchar(255)
- GROUP::character — varying)::text)))
admin
- id — int8 — 기본 키 — NOT NULL
- created_at — timestamp(6)
- email — varchar(255) — NOT NULL
- name — varchar(255) — NOT NULL
- password — varchar(255) — NOT NULL
- updated_at — timestamp(6)
app_user
- id — int8 — 기본 키 — NOT NULL
- created_at — timestamp(6)
- email — varchar(255) — NOT NULL
- name — varchar(255) — NOT NULL
- provider — varchar(255) — NOT NULL
- provider_user_id — varchar(255) — NOT NULL
- updated_at — timestamp(6)
- profile_image_key — varchar(255)
- fee_discount_count — int4 — NOT NULL
daily_quiz
- id — int8 — 기본 키 — NOT NULL
- active — bool — NOT NULL
- correct_answer — varchar(1) — NOT NULL
- difficulty — varchar(20) — NOT NULL
- explanation — varchar(500) — NOT NULL
- option_a — varchar(200)
- option_b — varchar(200)
- option_c — varchar(200)
- option_d — varchar(200)
- question — varchar(500) — NOT NULL
- type — varchar(20) — NOT NULL
dissolution_vote
- id — int8 — 기본 키 — NOT NULL
- completed_at — timestamp(6)
- created_at — timestamp(6) — NOT NULL
- deadline — timestamp(6) — NOT NULL
- status — varchar(255) — NOT NULL
- group_id — int8 — 외래 키 → groups.id — NOT NULL
- AWAITING_EXECUTION_CONFIRM::character — varying
- APPROVED::character — varying
- EXECUTED::character — varying
- REJECTED::character — varying
- CANCELED::character — varying)::text)))
dissolution_vote_record
- id — int8 — 기본 키 — NOT NULL
- agreed — bool — NOT NULL
- user_key — varchar(255) — NOT NULL
- voted_at — timestamp(6) — NOT NULL
- vote_id — int8 — 외래 키 → dissolution_vote.id — NOT NULL
faq
- id — int8 — 기본 키 — NOT NULL
- answer — text — NOT NULL
- created_at — timestamp(6)
- is_deleted — bool — NOT NULL
- question — varchar(255) — NOT NULL
- updated_at — timestamp(6)
favorite_stock
- id — int8 — 기본 키 — NOT NULL
- created_at — timestamp(6) — NOT NULL
- app_user_id — int8 — 외래 키 → app_user.id — NOT NULL
- stock_id — int8 — 외래 키 → stock.id — NOT NULL
feed_post
- id — int8 — 기본 키 — NOT NULL
- comment_count — int8 — NOT NULL
- content — text — NOT NULL
- created_at — timestamp(6)
- like_count — int8 — NOT NULL
- stock_codes — varchar(500)
- thumbnail_url — varchar(500)
- title — varchar(120) — NOT NULL
- updated_at — timestamp(6)
- video_url — varchar(500)
- app_user_id — int8 — 외래 키 → app_user.id — NOT NULL
- official — bool — NOT NULL
feed_post_like
- id — int8 — 기본 키 — NOT NULL
- created_at — timestamp(6)
- app_user_id — int8 — 외래 키 → app_user.id — NOT NULL
- feed_post_id — int8 — 외래 키 → feed_post.id — NOT NULL
group_invitation
- id — int8 — 기본 키 — NOT NULL
- created_at — timestamp(6) — NOT NULL
- invitee_user_id — varchar(255) — NOT NULL
- status — varchar(255) — NOT NULL
- group_id — int8 — 외래 키 → groups.id — NOT NULL
- ACCEPTED::character — varying
- REJECTED::character — varying)::text)))
group_member
- id — int8 — 기본 키 — NOT NULL
- joined_at — timestamp(6) — NOT NULL
- user_id — varchar(255) — NOT NULL
- user_key — varchar(255) — NOT NULL
- group_id — int8 — 외래 키 → groups.id — NOT NULL
group_order_proposal
- id — int8 — 기본 키 — NOT NULL
- created_at — timestamp(6)
- executed_at — timestamp(6)
- execution_confirmed_at — timestamp(6)
- note — varchar(255)
- order_type — varchar(255) — NOT NULL
- quantity — int8 — NOT NULL
- requested_price — int8
- side — varchar(255) — NOT NULL
- status — varchar(255) — NOT NULL
- unanimous_approved_at — timestamp(6)
- updated_at — timestamp(6)
- proposer_app_user_id — int8 — 외래 키 → app_user.id — NOT NULL
- stock_id — int8 — 외래 키 → stock.id — NOT NULL
- stock_account_id — int8 — 외래 키 → stock_account.id — NOT NULL
- LIMIT::character — varying)::text)))
- SELL::character — varying)::text)))
- REJECTED::character — varying
- UNANIMOUS_APPROVED::character — varying
- AWAITING_EXECUTION_CONFIRM::character — varying
- EXECUTION_CONFIRMED::character — varying
- EXECUTED::character — varying
- EXECUTION_CANCELED::character — varying)::text)))
group_order_vote
- id — int8 — 기본 키 — NOT NULL
- created_at — timestamp(6)
- decision — varchar(255) — NOT NULL
- updated_at — timestamp(6)
- voted_at — timestamp(6)
- proposal_id — int8 — 외래 키 → group_order_proposal.id — NOT NULL
- voter_app_user_id — int8 — 외래 키 → app_user.id — NOT NULL
- REJECT::character — varying)::text)))
groups
- id — int8 — 기본 키 — NOT NULL
- created_at — timestamp(6) — NOT NULL
- group_name — varchar(255) — NOT NULL
- leader_user_key — varchar(255) — NOT NULL
- status — varchar(255) — NOT NULL
- account_id — int8 — 외래 키 → account.id
- cash_balance — int8 — NOT NULL
- stock_account_name — varchar(255) — NOT NULL
- stock_account_number — varchar(255) — NOT NULL
- category — varchar(255)
- end_date — date
- group_image_key — varchar(255)
- member_contribution — int8
- target_amount — int8
- DISSOLVING::character — varying
- DISSOLVED::character — varying)::text)))
holding
- id — int8 — 기본 키 — NOT NULL
- average_price — int8 — NOT NULL
- created_at — timestamp(6)
- quantity — int8 — NOT NULL
- updated_at — timestamp(6)
- app_user_id — int8 — 외래 키 → app_user.id — NOT NULL
- stock_id — int8 — 외래 키 → stock.id — NOT NULL
- stock_account_id — int8 — 외래 키 → stock_account.id
- investment_account_id — int8 — 외래 키 → investment_account.id
invest_vote
- id — int8 — 기본 키 — NOT NULL
- amount — int8 — NOT NULL
- completed_at — timestamp(6)
- created_at — timestamp(6) — NOT NULL
- proposer_user_key — varchar(255) — NOT NULL
- reason — varchar(500)
- status — varchar(255) — NOT NULL
- stock_code — varchar(255) — NOT NULL
- stock_name — varchar(255) — NOT NULL
- title — varchar(255) — NOT NULL
- group_id — int8 — 외래 키 → groups.id — NOT NULL
- limit_price — int8
- order_type — varchar(255) — NOT NULL
- AWAITING_EXECUTION_CONFIRM::character — varying
- APPROVED::character — varying
- EXECUTED::character — varying
- REJECTED::character — varying
- CANCELED::character — varying)::text)))
invest_vote_record
- id — int8 — 기본 키 — NOT NULL
- agreed — bool — NOT NULL
- user_key — varchar(255) — NOT NULL
- voted_at — timestamp(6) — NOT NULL
- invest_vote_id — int8 — 외래 키 → invest_vote.id — NOT NULL
investment_account
- id — int8 — 기본 키 — NOT NULL
- created_at — timestamp(6)
- investment_account_name — varchar(255) — NOT NULL
- investment_account_no — varchar(255) — NOT NULL
- status — varchar(255) — NOT NULL
- updated_at — timestamp(6)
- app_user_id — int8 — 외래 키 → app_user.id — NOT NULL
- cash_account_id — int8 — 외래 키 → account.id
- cash_balance — int8 — NOT NULL
- CLOSED::character — varying)::text)))
investment_option
- id — int8 — 기본 키 — NOT NULL
- description — varchar(255)
- icon — varchar(255)
- score — float8
- title — varchar(255)
- tone — varchar(255)
- question_id — int8 — 외래 키 → investment_question.id — NOT NULL
investment_propensity
- id — int8 — 기본 키 — NOT NULL
- created_at — timestamp(6)
- dividend_preference — float8
- long_term_investment — float8
- market_sensitivity — float8
- persona_description — text
- persona_name — varchar(255)
- risk_preference — float8
- social_contribution — float8
- tech_affinity — float8
- updated_at — timestamp(6)
- app_user_id — int8 — 외래 키 → app_user.id — NOT NULL
investment_question
- id — int8 — 기본 키 — NOT NULL
- axis — varchar(255) — NOT NULL
- content — varchar(500) — NOT NULL
- sequence — int4
member
- id — int8 — 기본 키 — NOT NULL
- created — varchar(255)
- finance_link_status — varchar(255)
- finance_linked_at — timestamp(6)
- institution_code — varchar(255)
- modified — varchar(255)
- user_id — varchar(255) — NOT NULL
- user_key — varchar(255)
- user_name — varchar(255)
- app_user_id — int8 — 외래 키 → app_user.id
notification_preference
- id — int8 — 기본 키 — NOT NULL
- all_enabled — bool — NOT NULL
- created_at — timestamp(6)
- group_enabled — bool — NOT NULL
- price_enabled — bool — NOT NULL
- updated_at — timestamp(6)
- app_user_id — int8 — 외래 키 → app_user.id — NOT NULL
push_token
- id — int8 — 기본 키 — NOT NULL
- created_at — timestamp(6)
- device_type — varchar(32) — NOT NULL
- enabled — bool — NOT NULL
- token — varchar(512) — NOT NULL
- updated_at — timestamp(6)
- app_user_id — int8 — 외래 키 → app_user.id — NOT NULL
quiz_record
- id — int8 — 기본 키 — NOT NULL
- answered_at — timestamp(6) — NOT NULL
- correct — bool — NOT NULL
- quiz_date — date — NOT NULL
- selected_answer — varchar(1) — NOT NULL
- app_user_id — int8 — 외래 키 → app_user.id — NOT NULL
- quiz_id — int8 — 외래 키 → daily_quiz.id — NOT NULL
recent_transfer_recipient
- id — int8 — 기본 키 — NOT NULL
- bank_name — varchar(255)
- last_transferred_at — timestamp(6) — NOT NULL
- recipient_account_no — varchar(255) — NOT NULL
- recipient_name — varchar(255)
- transfer_count — int8 — NOT NULL
- app_user_id — int8 — 외래 키 → app_user.id — NOT NULL
recent_viewed_stock
- id — int8 — 기본 키 — NOT NULL
- last_viewed_at — timestamp(6)
- view_count — int8 — NOT NULL
- app_user_id — int8 — 외래 키 → app_user.id — NOT NULL
- stock_id — int8 — 외래 키 → stock.id — NOT NULL
shortform
- id — varchar(36) — 기본 키 — NOT NULL
- ai_summary — text
- created_at — timestamp(6)
- duration_seconds — int4
- like_count — int8 — NOT NULL
- official — bool — NOT NULL
- status — varchar(20) — NOT NULL
- thumbnail_key — varchar(500) — NOT NULL
- title — varchar(100)
- uploader_id — int8 — NOT NULL
- video_key — varchar(500) — NOT NULL
- view_count — int8 — NOT NULL
- ACTIVE::character — varying)::text)))
shortform_like
- id — int8 — 기본 키 — NOT NULL
- created_at — timestamp(6)
- shortform_id — varchar(36) — NOT NULL
- user_id — int8 — NOT NULL
shortform_stock
- id — int8 — 기본 키 — NOT NULL
- market — varchar(20) — NOT NULL
- shortform_id — varchar(36) — NOT NULL
- stock_name — varchar(100) — NOT NULL
- stock_ticker — varchar(20) — NOT NULL
shortform_stt_result
- shortform_id — varchar(36) — 기본 키 — NOT NULL
- created_at — timestamp(6)
- status — varchar(20) — NOT NULL
- summary_1 — text
- summary_2 — text
- summary_3 — text
- transcript — text
- updated_at — timestamp(6)
- COMPLETED::character — varying
- FAILED::character — varying)::text)))
shortform_view
- id — int8 — 기본 키 — NOT NULL
- shortform_id — varchar(36) — NOT NULL
- user_id — int8 — NOT NULL
- viewed_at — timestamp(6)
stock
- id — int8 — 기본 키 — NOT NULL
- active — bool — NOT NULL
- code — varchar(12) — NOT NULL
- created_at — timestamp(6)
- market — varchar(20) — NOT NULL
- name — varchar(100) — NOT NULL
- sector — varchar(100) — NOT NULL
- updated_at — timestamp(6)
- fifty_two_week_high_price — int8
- fifty_two_week_low_price — int8
- fundamentals_updated_at — timestamp(6)
- operating_profit_margin — float8
stock_account
- id — int8 — 기본 키 — NOT NULL
- account_number — varchar(255) — NOT NULL
- created_at — timestamp(6)
- linked_cash_account_no — varchar(255)
- nickname — varchar(255) — NOT NULL
- status — varchar(255) — NOT NULL
- type — varchar(255) — NOT NULL
- updated_at — timestamp(6)
- owner_app_user_id — int8 — 외래 키 → app_user.id — NOT NULL
- INACTIVE::character — varying)::text)))
- GROUP::character — varying)::text)))
stock_account_member
- id — int8 — 기본 키 — NOT NULL
- created_at — timestamp(6)
- joined_at — timestamp(6)
- role — varchar(255) — NOT NULL
- status — varchar(255) — NOT NULL
- updated_at — timestamp(6)
- app_user_id — int8 — 외래 키 → app_user.id — NOT NULL
- stock_account_id — int8 — 외래 키 → stock_account.id — NOT NULL
- MEMBER::character — varying)::text)))
- ACTIVE::character — varying
- REJECTED::character — varying)::text)))
stock_batch_job_state
- id — int8 — 기본 키 — NOT NULL
- created_at — timestamp(6) — NOT NULL
- job_type — varchar(50) — NOT NULL
- last_completed_at — timestamp(6)
- last_message — varchar(500)
- last_started_at — timestamp(6)
- last_stock_code — varchar(20)
- running — bool — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- MINUTE_BACKFILL::character — varying
- FUNDAMENTALS_SYNC::character — varying)::text)))
stock_daily_candle
- id — int8 — 기본 키 — NOT NULL
- close_price — int8 — NOT NULL
- created_at — timestamp(6)
- high_price — int8 — NOT NULL
- low_price — int8 — NOT NULL
- open_price — int8 — NOT NULL
- trade_date — date — NOT NULL
- updated_at — timestamp(6)
- volume — int8 — NOT NULL
- stock_id — int8 — 외래 키 → stock.id — NOT NULL
stock_minute_candle
- id — int8 — 기본 키 — NOT NULL
- candle_time — timestamp(6) — NOT NULL
- close_price — int8 — NOT NULL
- created_at — timestamp(6)
- high_price — int8 — NOT NULL
- low_price — int8 — NOT NULL
- open_price — int8 — NOT NULL
- updated_at — timestamp(6)
- volume — int8 — NOT NULL
- stock_id — int8 — 외래 키 → stock.id — NOT NULL
stock_order_execution
- id — int8 — 기본 키 — NOT NULL
- amount — int8 — NOT NULL
- executed_at — timestamp(6)
- external_execution_id — varchar(255)
- message — varchar(255)
- price — int8 — NOT NULL
- quantity — int8 — NOT NULL
- stock_order_id — int8 — 외래 키 → virtual_order.id — NOT NULL
user_follow
- id — int8 — 기본 키 — NOT NULL
- created_at — timestamp(6)
- followee_id — int8 — 외래 키 → app_user.id — NOT NULL
- follower_id — int8 — 외래 키 → app_user.id — NOT NULL
user_tag_weight
- stock_ticker — varchar(20) — 기본 키 — NOT NULL
- user_id — int8 — 기본 키 — NOT NULL
- stock_name — varchar(100) — NOT NULL
- updated_at — timestamp(6)
- weight — int4 — NOT NULL
virtual_order
- id — int8 — 기본 키 — NOT NULL
- amount — int8 — NOT NULL
- executed_at — timestamp(6)
- executed_price — int8 — NOT NULL
- executed_quantity — int8 — NOT NULL
- external_order_id — varchar(255)
- message — varchar(255)
- ordered_at — timestamp(6)
- price — int8 — NOT NULL
- quantity — int8 — NOT NULL
- side — varchar(255)
- source — varchar(255)
- status — varchar(255)
- app_user_id — int8 — 외래 키 → app_user.id — NOT NULL
- stock_id — int8 — 외래 키 → stock.id — NOT NULL
- order_type — varchar(255)
- stock_account_id — int8 — 외래 키 → stock_account.id
- investment_account_id — int8 — 외래 키 → investment_account.id
- LIMIT::character — varying)::text)))
- SELL::character — varying)::text)))
- FINANCE::character — varying)::text)))
- SUBMITTED::character — varying
- PARTIALLY_FILLED::character — varying
- FILLED::character — varying
- CANCELED::character — varying
- REJECTED::character — varying)::text)))