WALLET.GG
Tables (7)
accounts_savedvideo
- id — integer — Primary key — NOT NULL
- video_id — varchar(50) — NOT NULL
- title — varchar(200) — NOT NULL
- user_id — bigint — NOT NULL
- id (id2) — integer — Foreign key → accounts_user.id — NOT NULL
accounts_user
- id — integer — Primary key — NOT NULL
- username — varchar(150) — NOT NULL
- nickname — varchar(20) — NOT NULL
- age — integer — NOT NULL
- money — integer — NOT NULL
- salary — integer — NOT NULL
- investment_persona — varchar(20)
- description — text — NOT NULL
- profile_img — varchar(100)
articles_article
- id — integer — Primary key — NOT NULL
- title — varchar(100) — NOT NULL
- content — text — NOT NULL
- created_at — datetime — NOT NULL
- user_id — bigint — NOT NULL
- id (id2) — integer — Foreign key → accounts_user.id — NOT NULL
articles_comment
- id — integer — Primary key — NOT NULL
- content — text — NOT NULL
- article_id — bigint — NOT NULL
- user_id — bigint — NOT NULL
- id (id2) — integer — Foreign key → articles_article.id — NOT NULL
products_product
- id — integer — Primary key — NOT NULL
- fin_prdt_nm — text — NOT NULL
- kor_co_nm — text — NOT NULL
- product_type — varchar(20) — NOT NULL
- id (id2) — integer — Foreign key → accounts_user.id — NOT NULL
products_productoption
- product_id — bigint — Primary key — NOT NULL
- intr_rate — real — NOT NULL
- save_trm — integer
- id — integer — NOT NULL
- id (id2) — integer — Foreign key → products_product.id — NOT NULL
products_userportfolio
- id — integer — Primary key — NOT NULL
- analysis_result — text — NOT NULL
- created_at — datetime — NOT NULL
- user_id — bigint — NOT NULL
- id (id2) — integer — Foreign key → accounts_user.id — NOT NULL