pjt-10-ERD - 2024-11-26 04:35:53
Tables (11)
Article (게시글)
- article_id (Key) — integer — Primary key — NOT NULL
- user_id (Key2) — integer — Foreign key → User.user_id
- category (Field) — varchar(50)
- title (Field2) — varchar(100)
- content (Field3) — text
- created_at (Field4) — date
- updated_at (Field5) — date
Comment (댓글)
- id (Key) — integer — Primary key — NOT NULL
- article_id (Key2) — integer — Foreign key → Article.article_id — NOT NULL
- user_id (Key22) — integer — Foreign key → Article.user_id
- user_id (Key3) — integer — Foreign key → User.user_id
- content (Field3) — text
DepositOptions (예금옵션)
- depositOption_id (Key) — integer — Primary key — NOT NULL
- diposit_id (Key2) — integer — Foreign key → DepositProducts.diposit_id — NOT NULL
- fin_prdt_cd (Field) — text
- intr_rate_type_nm (Field2) — varchar(100)
- intr_rate (Field3) — real
- intr_rate2 (Field4) — real
- save_trm (Field5) — integer
DepositProducts (예금상품)
- diposit_id (Key) — integer — Primary key — NOT NULL
- fin_prdt_cd (Field) — text
- kor_co_nm (Field2) — text
- fin_prdt_nm (Field3) — text
- etc_note (Field4) — text
- join_deny (Field5) — integer
- join_member (Field6) — text
- join_way (Field7) — text
- spcl_cnd (Field8) — text
- mtrt_int (Field9) — text
- max_limit (Field10) — integer
- dcls_strt_day (Field11) — text
- dcls_end_day (Field12) — text
- love_count (Field13) — text
Fininfo (유저금융정보)
- fininfo_id (Key) — integer — Primary key — NOT NULL
- user_id (Key3) — integer — Foreign key → User.user_id
- job (Field) — varchar(50)
- monthly_income (Field2) — decimal
- annual_income (Field3) — decimal
- current_assets (Field4) — decimal
- fixed_expenses (Field5) — decimal
- variable_expenses (Field6) — decimal
- goal_type (Field7) — varchar(100)
- goal_date (Field8) — integer
- prefers_stability (Field9) — bool
- preference_type (Field10) — varchar(100)
- mbti (Field11) — varchar(4)
Profile (유저프로필)
- profile_id (Key) — INTEGER — Primary key — NOT NULL
- user_id (Key3) — integer — Foreign key → User.user_id
- age (Field) — integer
- money (Field2) — decimal
- nickname (Field3) — varchar(30)
- desiredSubscriptionPeriod (Field4) — integer
- mainBank (Field5) — varchar(30)
- profile_img (Field6) — varchar(30)
SavingOptions (적금옵션)
- savingOption_id (Key) — integer — Primary key — NOT NULL
- saving_id (Key2) — integer — Foreign key → SavingProducts.saving_id — NOT NULL
- fin_prdt_cd (Field) — text
- rsrv_type_nm (Field6) — varchar(100)
- intr_rate_type_nm (Field2) — varchar(100)
- intr_rate (Field3) — real
- intr_rate2 (Field4) — real
- save_trm (Field5) — integer
SavingProducts (적금상품)
- saving_id (Key) — integer — Primary key — NOT NULL
- fin_prdt_cd (Field) — text
- kor_co_nm (Field2) — text
- fin_prdt_nm (Field3) — text
- etc_note (Field4) — text
- join_deny (Field5) — integer
- join_member (Field6) — text
- join_way (Field7) — text
- spcl_cnd (Field8) — text
- mtrt_int (Field9) — text
- max_limit (Field10) — integer
- dcls_strt_day (Field11) — text
- dcls_end_day (Field12) — text
- love_count (Field13) — text
User (회원)
- user_id (Key) — integer — Primary key
- username (Field4) — varchar(150) — NOT NULL
- password (Field) — varchar(128) — NOT NULL
- is_superuser (Field2) — bool — NOT NULL
accounts_profile_liked_products_deposit (relation)
- profile_id (Key) — INTEGER — Foreign key → Profile.profile_id — NOT NULL
- user_id (Key3) — integer — Foreign key → Profile.user_id
- diposit_id (Key2) — integer — Foreign key → DepositProducts.diposit_id — NOT NULL
accounts_profile_liked_products_saving (relation3)
- profile_id (Key) — INTEGER — Foreign key → Profile.profile_id — NOT NULL
- user_id (Key3) — integer — Foreign key → Profile.user_id
- saving_id (Key2) — integer — Foreign key → SavingProducts.saving_id — NOT NULL