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