myBank
Tables (5)
Category (Untitled3)
- categoryId (카테고리 아이디) — Primary key — NOT NULL
- categoryName (식비, 교통비 등)
- description (설명)
- Field
Money (나의현금)
- MoneyId (Key) — CHAR(10) — Primary key — NOT NULL
- userId (Key2) — Char(10) — Foreign key → User.userId — NOT NULL
- Total_Money (현재 자산) — INT
MoneyLog (Untitled2)
- logId (아이디) — Primary key — NOT NULL
- logDay (기록날자) — DATETIME
- card (카드결제) — boolean
- cash (현금결제)
- pay (계좌이체)
- checkCard (체크카드결제)
- amount (거래량) — INT
- isIncome (수입/지출여부) — BOOLEAN
- MoneyId (Key) — CHAR(10) — Foreign key → Money.MoneyId — NOT NULL
- categoryId (카테고리 아이디) — Foreign key → Category.categoryId — NOT NULL
Statistics (Untitled4)
- statisticsId (통계아이디) — Primary key — NOT NULL
- Month (Field)
- totalIncome (Field2)
- totalExpense (Field3)
- totalSavings (Field4)
- userId (Key) — Char(10) — Foreign key → User.userId — NOT NULL
User (Untitled)
- userId (Key) — Char(10) — Primary key — NOT NULL
- account (아이디) — CHAR(10)
- password (비밀번호) — CHAR(8)
- SEX (성별) — CHAR(2)
- AGE (나이) — INT(2)
- INTRODUCE (자기소개) — CHAR(100)
- image (프로필사진) — CHAR(500)
- NAME (이름) — CHAR(8)
- Nickname (닉네임) — CHAR(8)
- Field