final pjt
Tables (6)
Article (Untitled4)
- article_id (Key) — Primary key — NOT NULL
- author (FK) — text — Foreign key → User.user_id — NOT NULL
- title (Field) — text
- content (Field2) — text
- create_at (Field3) — datetime
- updated_at (Field4) — datetime
Commnet (Untitled5)
- comment_id (Key) — Primary key — NOT NULL
- article (FK) — text — Foreign key → Article.article_id — NOT NULL
- author (FK2) — text — Foreign key → User.user_id — NOT NULL
- content (Field) — text
- created_at (Field2) — datetime
- updated_at (Field3) — datetime
DepositOptions (Untitled3)
- options_id (Key) — Primary key — NOT NULL
- product (FK) — text — Foreign key → DepositProducts.deposit_id — NOT NULL
- fin_prdt_cd (Field) — text
- save_trm (Field2) — int
- intr_rate (Field3) — float
- Field4 — float
DepositProducts (Untitled2)
- deposit_id (Key) — Primary key — NOT NULL
- kor_co_nm (Field) — text
- fin_prdt_nm (Field2) — text
- dcls_month (Field4) — date
- join_way (Field5) — text
- fin_prdt_cd (Field3) — text
- etc_note (Field6) — text
- spcl_cnd (Field7) — text
User (Untitled)
- user_id (Key) — Primary key — NOT NULL
- username (Field2) — text
- email (Field6) — text
- userid (Field3) — text
- password (Field4) — text
- phonenumber (Field5) — int
UserDeposit (Untitled6)
- list_id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → User.user_id — NOT NULL
- deposit_id (Key3) — Foreign key → DepositProducts.deposit_id — NOT NULL
- options_id (Key4) — Foreign key → DepositOptions.options_id — NOT NULL