pjt-10-ERD

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
  • 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 (Key2) — 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 (Key2) — 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 (Key3) — 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 (Key2) — integer — Foreign key → Profile.user_id
  • diposit_id (Key3) — 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 (Key2) — integer — Foreign key → Profile.user_id
  • saving_id (Key3) — integer — Foreign key → SavingProducts.saving_id — NOT NULL