kimparkwee

Tables (4)

Asset (Untitled2)

  • PK (asset_id) — Long — Primary key — NOT NULL
  • PK (user_id) — Long — Foreign key → User.PK — NOT NULL
  • PK (bank_id) — Long — Foreign key → Bank.PK — NOT NULL
  • 계좌 번호 (account_number) — varchar((50)
  • 계좌잔액 (balance) — Long
  • Field

Bank (Untitled3)

  • PK (bank_id) — Long — Primary key — NOT NULL
  • 은행명 (bank_name) — varchar(50)
  • (Field2)

Trade (Untitled4)

  • Key (trade_id) — Long — Primary key — NOT NULL
  • PK (asset_id) — Long — Foreign key → Asset.PK — NOT NULL
  • PK (user_id) — Long — Foreign key → Asset.PK — NOT NULL
  • PK (bank_id) — Long — Foreign key → Asset.PK — NOT NULL
  • 금액 (amount) — Long
  • 날짜 (datetime) — datetime
  • 타입(입출금) (type) — varchar(20)

User (Untitled)

  • PK (user_id) — Long — Primary key — NOT NULL
  • 이메일 (email) — varchar(50)
  • 비밀번호 (password) — varchar(300)
  • 사용자명 (user_name) — varchar(50)
  • 생성날짜 (created_at) — DATETIME