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)