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