Shinhan Campus GlobalLink

Tables (13)

account_application

  • app_id — UUID
  • status — TEXT
  • submitted_at — TIMESTAMP
  • decision_at — TIMESTAMP
  • user_id — UUID
  • prod_id — UUID

app_user

  • user_id — UUID
  • email — TEXT
  • phone — TEXT
  • password_hash — TEXT
  • social_provider — TEXT
  • provider_uid — TEXT
  • user_type — TEXT
  • nationality — TEXT
  • preferred_lang — CHAR(2)
  • campus_id — UUID

campus

  • campus_id — UUID
  • name — TEXT — NOT NULL
  • univ_name — TEXT — NOT NULL
  • city — TEXT — NOT NULL

chat_message

  • msg_id — UUID
  • session_id — UUID
  • sender — TEXT
  • text — TEXT — NOT NULL
  • lang_code — CHAR(2)
  • created_at — TIMESTAMP — NOT NULL

chat_session

  • session_id — UUID
  • language — CHAR(2)
  • started_at — TIMESTAMP — NOT NULL
  • ended_at — TIMESTAMP
  • user_id — UUID

event

  • event_id — UUID
  • title — TEXT — NOT NULL
  • desc — TEXT
  • start_date — DATE
  • end_date — DATE
  • campus_id — UUID

exchange_rate_favorite

  • fav_id — UUID
  • currency_code — CHAR(3) — NOT NULL
  • user_id — UUID
  • UNIQUE(user_id, — currency_code)

exchange_rate_log

  • rate_id — UUID
  • currency_code — CHAR(3) — NOT NULL
  • rate — NUMERIC(12,6) — NOT NULL
  • timestamp — TIMESTAMP — NOT NULL

locale_string

  • msg_key — TEXT — Primary key — NOT NULL
  • lang_code — CHAR(2) — Primary key — NOT NULL
  • text — TEXT — NOT NULL

product

  • prod_id — UUID
  • name — TEXT — NOT NULL
  • interest_rate — NUMERIC(6,3)
  • term_months — INT
  • eligibility_json — JSONB
  • cat_id — UUID

product_category

  • cat_id — UUID
  • name — TEXT — NOT NULL
  • description — TEXT

product_recommendation

  • rec_id — UUID
  • score — NUMERIC(4,3) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • user_id — UUID
  • prod_id — UUID

verification_document

  • doc_id — UUID
  • doc_type — TEXT
  • status — TEXT
  • file_url — TEXT — NOT NULL
  • user_id — UUID