2-2카카오뱅크
테이블 (3)
Account (Untitled2)
- idx (pk) — BIGINT — 기본 키 — NOT NULL
- user_idx (fk) — BIGINT — 외래 키 → user.idx — NOT NULL
- account_number (Field) — VARCHAR
- money (Field2) — BIGINT
- password (Field3) — VARCHAR
- bank (Field4) — int
- nickname (Field5) — VARCHAR
UsingAccountRecord (Untitled3)
- idx (pk) — BIGINT — 기본 키 — NOT NULL
- account_idx (fk) — BIGINT — 외래 키 → Account.idx — NOT NULL
- date (Field) — Date
- money (Field2) — BIGINT
- using_type (Field3) — int
- name (Field4) — VARCHAR
user (Untitled)
- idx (pk) — BIGINT — 기본 키 — NOT NULL
- id (Field) — VARCHAR
- password (Field2) — VARCHAR
- email (Field9) — VARCHAR
- phone_number (Field3) — VARCHAR
- resident__registration_number (Field4) — VARCHAR
- name (Field5) — VARCHAR
- nickname (Field6) — VARCHAR
- profile_img (Field7) — VARCHAR
- simple_number (Field8) — INT(11)