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