DGB
Tables (5)
Account (계좌)
- aId (Key) — Auto — Primary key — NOT NULL
- accNum (Key2) — Integer — Primary key — NOT NULL
- password (Field) — Integer
- balance (Field2) — Integer
- ownerId (Field3) — Char
- ownerName (Field4) — Char
- title (Field5) — Integer
- card (Field6) — Char
Advertising (광고상품)
- aId (Key) — auto — Primary key — NOT NULL
- aName (Field) — char
- title (Field2) — char
- contents (Field3) — text
- img (Field4) — char
Card (계좌 카드)
- cId (Key) — Auto — Primary key — NOT NULL
- cName (Field) — char
- contents (Field2) — text
- img (Field3) — char
TranInfo (거래내역)
- tId (Key) — Auto — Primary key — NOT NULL
- send_accNum (Field) — char
- send_name (Field2) — char
- receive_accNum (Field3) — char
- receive_name (Field4) — char
- money (Field5) — Integer
- trade_date (Field6) — char
- trade_time (Field7) — char
- comment (Field8) — text
User (사용자)
- id (Key) — Char — Primary key — NOT NULL
- password (Field) — Char
- userName (Field2) — Char
- accCnt (Field3) — Integer
- cash (Field4) — Integer
- phoneNumber (Field5) — Char