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