wiseWallet

Tables (5)

AccountDetail (가계부 내역)

  • Key (id) — int — Primary key — NOT NULL
  • date (날짜) — date
  • priceSign (금액 부호) — char(1)
  • price (가격) — int
  • content (내용) — varchar(100)
  • createdAt (생성일) — datatime
  • userId (사용자) — int — Foreign key → User.Key — NOT NULL
  • payOption (결제수단) — int — Foreign key → PayOption.Key — NOT NULL
  • category (분류) — int — Foreign key → Category.Key — NOT NULL

Category (분류)

  • Key (id) — ind — Primary key — NOT NULL
  • categoryName (이름) — varchar(30)
  • sign (수입/지출) — char(1)

PayOption (결제 수단)

  • Key (id) — ind — Primary key — NOT NULL
  • optionName (이름) — varchar(30)
  • created_at (생성일) — datetime
  • userId (사용자) — int — Foreign key → User.Key — NOT NULL

Session (세션정보)

  • session_id (세션아이디) — varchar(128) — Primary key — NOT NULL
  • expires (만료일) — datetime
  • data (쿠키정보) — varchar()

User (사용자)

  • Key (id) — int — Primary key — NOT NULL
  • username (아이디) — varchar(20)
  • password (비밀번호) — varchar(128)
  • salt — varchar(64)