final_pjt3
Tables (10)
Comment
- Key — INTERGER — Primary key — NOT NULL
- Key2 — INTEGER — Foreign key → User.Key — NOT NULL
- Key22 — INTEGER — Foreign key → Post.Key2 — NOT NULL
- content — TEXT
- created_at — DATETIME
DepositProduct
- Key — INTEGER — Primary key — NOT NULL
- fin_prdt_cd — VARCHAR(100)
- kor_co_nm — VARCHAR(100)
- fin_prdt_nm — VARCHAR(200)
- etc_note — TEXT
- rate_6m — FLOAT
- rate_12m — FLOAT
- rate_24m — FLOAT
- rate_36m — FLOAT
FavoriteChannel
- Key — INTEGER — Primary key — NOT NULL
- Key2 — INTEGER — Foreign key → User.Key — NOT NULL
- channel_id — VARCHAR(100)
- channel_name — VARCHAR(255)
- thumbnail — TEXT
- saved_at — DATETIME
JoinedProduct
- Key — INTERGER — Primary key — NOT NULL
- Key2 — INTEGER — Foreign key → User.Key — NOT NULL
- Key3 — INTEGER — Foreign key → SavingProduct.Key — NOT NULL
- joined_at — DATETIME
JoinedSavingProduct
- Key — INTERGER — Primary key — NOT NULL
- Key2 — INTEGER — Foreign key → User.Key — NOT NULL
- Key3 — INTEGER — Foreign key → DepositProduct.Key — NOT NULL
- joined_at — DATETIME
MetalPrice
- Key — INTEGER — Primary key — NOT NULL
- metal — VARCHAR(10)
- date — DATE
- price — FLOAT
Post
- Key — INTERGER — Primary key — NOT NULL
- Key2 — INTEGER — Foreign key → User.Key — NOT NULL
- title — VARCHAR(100)
- content — TEXT
- created_at — DATETIME
SavedVideo
- Key — INTERGER — Primary key — NOT NULL
- Key2 — INTEGER — Foreign key → User.Key — NOT NULL
- video_id — VARCHAR(100)
- title — VARCHAR(255)
- thumbnail — TEXT
- saved_at — DATETIME
SavingProduct
- Key — INTEGER — Primary key — NOT NULL
- fin_prdt_cd — VARCHAR(100)
- kor_co_nm — VARCHAR(100)
- fin_prdt_nm — VARCHAR(200)
- etc_note — TEXT
- rate_6m — FLOAT
- rate_12m — FLOAT
- rate_24m — FLOAT
- rate_36m — FLOAT
User
- Key — INTEGER — Primary key — NOT NULL
- username — VARCHAR(150)
- email — VARCHAR(254)