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