hometax

Tables (3)

history (내역)

  • id (히스토리아이디) — INT — Primary key — NOT NULL
  • memberId (멤버아이디) — INT — Foreign key → member.id — NOT NULL
  • date (날짜) — DATE
  • cost (금액) — INT
  • category (분류) — VARCHAR(45)
  • way (결제수단) — VARCHAR(45)
  • content (내용) — VARCHAR(200)

member (멤버)

  • id (멤버아이디) — INT — Primary key — NOT NULL
  • userId (유저아이디) — VARCHAR(45)
  • password (비밀번호) — VARCHAR(255)
  • name (이름) — VARCHAR(45)

paymethod (결제수단)

  • id (결제수단아이디) — INT — Primary key — NOT NULL
  • memberId (멤버아이디) — INT — Foreign key → member.id — NOT NULL
  • method (결제수단) — VARCHAR(45)