fin-project
Tables (13)
article
- id — BIGINT — Primary key
- user_id — BIGINT — Primary key — NOT NULL
- id (id2) — BIGINT — Foreign key → customuser.id
- title — VARCHAR(30) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- content — TEXT
carbon
- id — BIGINT — Primary key
- spot_type — VARCHAR(10) — NOT NULL
- bas_dt — DATE — NOT NULL
- itms_nm — VARCHAR(100)
- clpr — DECIMAL(15,2)
- flt_rt — DECIMAL(15,2)
- hipr — DECIMAL(15,2)
- lopr — DECIMAL(15,2)
- mkp — DECIMAL(15,2)
- tr_prc — DECIMAL(20,2)
- trqu — DECIMAL(20,2)
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
cards_card
- id — SERIAL — Primary key
- user_id — BIGINT — Foreign key → customuser.id
- card_id — VARCHAR(100) — NOT NULL
- card_num — VARCHAR(20) — NOT NULL
- card_name — VARCHAR(100) — NOT NULL
- card_type — VARCHAR(20) — NOT NULL
- card_member — VARCHAR(10) — NOT NULL
- org_code — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
cards_cardapproval
- id — SERIAL — Primary key
- card_id — SERIAL — Foreign key → cards_card.id
- user_id — BIGINT — Foreign key → cards_card.user_id
- approved_num — VARCHAR(50) — NOT NULL
- approved_dtime — VARCHAR(14) — NOT NULL
- status — VARCHAR(2) — NOT NULL
- pay_type — VARCHAR(2) — NOT NULL
- merchant_name — VARCHAR(100) — NOT NULL
- merchant_regno — VARCHAR(20)
- approved_amt — DECIMAL(15, 2) — NOT NULL
- total_install_cnt — SMALLINT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
cards_cardbill
- id — SERIAL — Primary key
- id (id2) — BIGINT — Foreign key → customuser.id
- id (id3) — SERIAL — Foreign key → cards_card.id
- user_id — BIGINT — Foreign key → cards_card.user_id
- org_code — VARCHAR(20) — NOT NULL
- bill_year_month (bymd) — VARCHAR(6)
- payment_year_month_day (pymd) — VARCHAR(8)
- payment_date (pd) — DATE
- total_amount (ta) — DECIMAL(15, 2) — NOT NULL
- created_at (ca) — TIMESTAMP
- updated_at (ua) — TIMESTAMP
customuser
- id — BIGINT — Primary key
- password — VARCHAR(128) — NOT NULL
- last_login — DATETIME(6)
- is_superuser — BOOLEAN — NOT NULL
- username — VARCHAR(150)
- first_name — VARCHAR(150) — NOT NULL
- last_name — VARCHAR(150) — NOT NULL
- is_staff — BOOLEAN — NOT NULL
- is_active — BOOLEAN — NOT NULL
- date_joined — DATETIME(6) — NOT NULL
- useremail — VARCHAR(254) — NOT NULL
- nickname — VARCHAR(30) — NOT NULL
gold
- id — BIGINT — Primary key
- user_id (id22) — BIGINT — Foreign key → product.user_id
- spot_type — VARCHAR(10) — NOT NULL
- itms_nm — VARCHAR(100)
- bas_dt — DATE — NOT NULL
- clpr — DECIMAL(15,2)
- flt_rt — DECIMAL(15,2)
- hipr — DECIMAL(15,2)
- lopr — DECIMAL(15,2)
- mkp — DECIMAL(15,2)
- tr_prc — DECIMAL(20,2)
- trqu — DECIMAL(20,2)
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
oil
- id — BIGINT — Primary key
- spot_type — VARCHAR(10) — NOT NULL
- bas_dt — DATE — NOT NULL
- oil_ctg — VARCHAR(20)
- wt_avg_prc_cptn (wt_avg_) — DECIMAL(15,2)
- wt_avg_prc_disc (wt_) — DECIMAL(15,2)
- trqu — DECIMAL(20,2)
- tr_prc — DECIMAL(20,2)
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
option
- id — BIGINT — Primary key
- prd_id — BIGINT — Foreign key → product.id
- user_id (id22) — BIGINT — Foreign key → product.user_id
- intr_rate_type — VARCHAR(100) — NOT NULL
- intr_rate_type_nm — VARCHAR(100) — NOT NULL
- rsrv_type — VARCHAR(100)
- rsrv_type_nm — VARCHAR(100)
- save_trm — VARCHAR(100)
- intr_rate — DOUBLE
- intr_rate2 — DOUBLE
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
product
- id — BIGINT — Primary key
- user_id (id22) — BIGINT — Foreign key → productbookmark.user_id
- join_deny — VARCHAR(10) — NOT NULL
- fin_prdt_nm — VARCHAR(100) — NOT NULL
- ord_num — VARCHAR(100) — NOT NULL
- fin_prdt_cd — VARCHAR(100) — NOT NULL
- kor_co_nm — VARCHAR(100) — NOT NULL
- mtrt_int — TEXT — NOT NULL
- spcl_cnd — TEXT
- etc_note — TEXT
- join_member — VARCHAR(100)
- join_way — VARCHAR(100)
- prd_type — VARCHAR(10) — NOT NULL
- dcls_strt_dat — DATE
- dcls_end_dat — DATE
- fin_co_subm_day — VARCHAR(20)
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
productbookmark
- id — BIGINT — Primary key
- user_id (id2) — BIGINT — Foreign key → customuser.id
- product_id — BIGINT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
spotproduct
- spot_type — VARCHAR(20) — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- content_type_id — INT
- object_id — INT
spotproductbookmark
- id — BIGINT — Primary key
- spot_product_id — BIGINT — Foreign key → customuser.id
- spot_type — VARCHAR(20) — Foreign key → spotproduct.spot_type — NOT NULL
- user_id — BIGINT — NOT NULL
- created_at — DATETIME(6) — NOT NULL