fundly

Tables (13)

AdditionalOption (finance_additionaloption)

  • id (Primary Key) — INT — Primary key — NOT NULL
  • financial_company_id (Foreign Key) — INT — Foreign key → FinancialCompany.id — NOT NULL
  • additional_product_id (Foreign Key2) — INT — Foreign key → AdditionalProduct.id — NOT NULL
  • save_type — CHAR(1)
  • reward_type — CHAR(1)
  • save_month — INT
  • interest_rate — FLOAT
  • max_interest_rate — FLOAT
  • come_from — CHAR(10)

AdditionalProduct (finance_additionalproduct)

  • id (Primary Key) — INT — Primary key — NOT NULL
  • financial_company_id (Foriegn Key) — INT — Foreign key → FinancialCompany.id — NOT NULL
  • product_name — CHAR(100)
  • product_type — CHAR(5)
  • special_condition — TEXT
  • join_way — TEXT
  • end_interest_rate — TEXT
  • join_deny — CHAR(10)
  • join_member — CHAR(100)
  • etc_note — TEXT
  • max_limit — INT
  • created_at — DATETIME
  • come_from — CHAR(10)

Comment (finance_comment)

  • id (Primany Key) — INT — Primary key — NOT NULL
  • post id (Foreign Key) — INT — Foreign key → Post.user id — NOT NULL
  • user id (Foreign Key2) — INT — Foreign key → User.id — NOT NULL
  • content — TEXT
  • created_at — DATETIME
  • updated_at — DATETIME

ConnectedToGoal (finance_connectedtogoal)

  • id (Primary Key) — INT — Primary key — NOT NULL
  • goal id (Foreign Key) — INT — Foreign key → Goal.user id — NOT NULL
  • user id (Foreign Key2) — INT — Foreign key → User.id — NOT NULL
  • financial_product_id (Foreign Key3) — INT — Foreign key → FinancialProduct.financial_company_id — NOT NULL
  • additional_product_id (Foriegn Key4) — INT — Foreign key → AdditionalProduct.financial_company_id — NOT NULL
  • option_id (Foriegn Key5) — INT — Foreign key → Option.id — NOT NULL
  • additional_option_id (Foriegn Key6) — INT — Foreign key → AdditionalOption.id — NOT NULL
  • current_amount — INT
  • target_amount — INT
  • start_date — DATE
  • duration_months — INT
  • is_active — BOOLEAN
  • created_at — DATETIME
  • updated_at — DATETIME

FinancialCompany (finance_financialcompany)

  • id (Primary Key) — INT — Primary key — NOT NULL
  • company_type — CHAR(6)
  • company_code — CHAR(20)
  • company_name — CHAR(20)
  • homepage_url — CHAR(200)
  • phone_number — CHAR(20)

FinancialProduct (finance_financialproduct)

  • id (Primary Key) — INT — Primary key — NOT NULL
  • financial_company_id (Foreign Key) — INT — Foreign key → FinancialCompany.id — NOT NULL
  • product_code — CHAR(50)
  • published_date — CHAR(6)
  • product_name — CHAR(100)
  • product_type — CHAR(5)
  • special_condition — TEXT
  • join_way — TEXT
  • end_interest_rate — TEXT
  • join_deny — CHAR(10)
  • join_member — CHAR(100)
  • etc_note — TEXT
  • max_limit — INT
  • product_start_date — DATE
  • product_end_date — DATE
  • submit_date — DATETIME
  • come_from — CHAR(10)

Goal (finance_goal)

  • id (Primary Key) — INT — Primary key — NOT NULL
  • user id (Foreign Key) — INT — Foreign key → User.id — NOT NULL
  • goal_name — CHAR(100)
  • product_type — CHAR(10)
  • saving_target_amount — INT
  • deposit_target_amount — INT
  • start_date — DATE
  • end_date — DATE
  • created_at — DATETIME
  • updated_at — DATETIME

Option (finance_option)

  • id (Primary Key) — INT — Primary key — NOT NULL
  • financial_company_id (Foreign Key) — INT — Foreign key → FinancialCompany.id — NOT NULL
  • financial_product_id (Foreign Key2) — INT — Foreign key → FinancialProduct.id — NOT NULL
  • save_type — CHAR(1)
  • reward_type — CHAR(1)
  • save_month — INT
  • interest_rate — FLOAT
  • max_interest_rate — FLOAT
  • come_from — CHAR(10)

Post (finance_post)

  • id (Primary Key) — INT — Primary key — NOT NULL
  • user id (Foreign Key) — INT — Foreign key → User.id — NOT NULL
  • title — CHAR(200)
  • content — TEXT
  • category — CHAR(10)
  • created_at — DATETIME
  • updated_at — DATETIME

Recommendation (finance_recommendation)

  • id (Primary Key) — INT — Primary key — NOT NULL
  • user id (Foreign Key) — INT — Foreign key → User.id — NOT NULL
  • created_at — DATETIME

Recommendation_Products (finance_recommendation_products)

  • recommendation id (Foreign Key) — INT — Foreign key → Recommendation.id — NOT NULL
  • financial_company_id (Foreign Key2) — INT — Foreign key → FinancialProduct.financial_company_id — NOT NULL

User (users_user)

  • id (Primary Key) — INT — Primary key — NOT NULL
  • username — CHAR(30) — NOT NULL
  • email — Email — NOT NULL
  • social_id — CHAR(50)
  • provider — CHAR(10)
  • birth_date — DATE
  • work_type — CHAR(20)
  • assets — CHAR(20)
  • salary — CHAR(20)
  • is_superuser — BOOLEAN
  • is_active — BOOLEAN
  • is_staff — BOOLEAN
  • created_at — DATETIME
  • updated_at — DATETIME

Wishlist (finance_wishlist)

  • id (Primary Key) — INT — Primary key — NOT NULL
  • user id (Foreign Key) — INT — Foreign key → User.id — NOT NULL
  • financial_product_id (Foreign Key2) — INT — Foreign key → FinancialProduct.financial_company_id — NOT NULL
  • additional_product_id (Foriegn Key3) — INT — Foreign key → AdditionalProduct.financial_company_id — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME