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)