123
Tables (12)
Article
- id — int — Primary key — NOT NULL
- title — varchar(100)
- content — text
- created_at — datetime
- updated_at — datetime
- user_id — int — Foreign key → User.id — NOT NULL
Attendance
- id — int — Primary key — NOT NULL
- date — date
- user_id — int — Foreign key → User.id — NOT NULL
BuySavingProducts
- Key — int — Primary key — NOT NULL
- user_id — int — Foreign key → User.id — NOT NULL
- product_id — int — Foreign key → SavingProducts.id — NOT NULL
- intr_rate — float
- intr_rate2 — float
Coments
- id — int — Primary key — NOT NULL
- contents — text
- created_at — datetime
- user_id — int — Foreign key → User.id — NOT NULL
- article_id — int — Foreign key → Article.id — NOT NULL
CopyOfBuyDepositProducts
- Key — int — Primary key — NOT NULL
- user_id — int — Foreign key → User.id — NOT NULL
- product_id — int — Foreign key → DepositProducts.id — NOT NULL
- intr_rate — float
- intr_rate2 — float
DepositOptions
- id — VARCHAR(255) — Primary key — NOT NULL
- intr_rate — float
- intr_rate2 — float
- fin_prdt_cd — VARCHAR(255)
- intr_rate_type_nm — varchar(100)
- save_trm — int
- product_id — int — Foreign key → DepositProducts.id — NOT NULL
DepositProducts
- id — int — Primary key — NOT NULL
- fin_prdt_cd — text
- kor_co_nm — text
- fin_prdt_nm — text
- etc_note — text
- join_deny — int
- join_member — text
- join_way — text
- sqcl_cnd — text
- max_limit — int
- dcls_start_day — varchar(50)
QNAComment
- id — int — Primary key — NOT NULL
- contents — text
- created_at — datetime
- user_id — int — Foreign key → User.id — NOT NULL
- article_id — int — Foreign key → QNAarticle.id — NOT NULL
QNAarticle
- id — int — Primary key — NOT NULL
- title — varchar(100)
- content — text
- created_at — datetime
- updated_at — datetime
- user_id — int — Foreign key → User.id — NOT NULL
SavingOptions
- id — VARCHAR(255) — Primary key — NOT NULL
- intr_rate — float
- intr_rate2 — float
- fin_prdt_cd — text
- intr_rate_type_nm — varchar(100)
- save_trm — int
- rsrv_type_nm — varchar(50)
- product_id — int — Foreign key → SavingProducts.id — NOT NULL
SavingProducts
- id — int — Primary key — NOT NULL
- fin_prdt_cd — text
- kor_co_nm — text
- fin_prdt_nm — text
- etc_note — text
- join_deny — int
- join_member — text
- join_way — text
- sqcl_cnd — text
- max_limit — int
- dcls_start_day — varchar(50)
User
- id — int — Primary key — NOT NULL
- username — varchar(150)
- password — varchar(128)
- nickname — varchar(255)
- email — varchar(254)
- age — int
- money — int
- gender — varchar(255)
- job — varchar(255)
- goal — varchar(255)
- points — int