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)