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)))