accountbook
Tables (3)
Untitled (accout_book_detail)
- Key (account_book_detail_no) — bigint — Primary key — NOT NULL — id
- Key (account_book_no) — bigint — Foreign key → Untitled.Key — NOT NULL — id
- Field (place) — varchar(255) — 사용처
- Field2 (amount) — bigint — NOT NULL — 금액
- Field3 (transaction_date) — timestamp — NOT NULL — 금액사용날짜 및 시간
- Field4 (transaction_type) — varchar(10) — NOT NULL — 수입,지출
- Field5 (memo) — varchar(255) — 메모
- Field6 (delete_yn) — varchar(1) — NOT NULL — 삭제여부
- Field7 (created_dt) — timestamp — 생성날짜
- Field8 (modified_dt) — timestamp — 수정날짜
Untitled (account_book)
- Key (account_book_no) — bigint — Primary key — NOT NULL — id
- Key (member_no) — bigint — Foreign key → member.Key — NOT NULL — id
- Field4 (account_book_name) — varchar(50) — NOT NULL — 가계부명
- Field8 (delete_yn) — varchar(1) — NOT NULL — 삭제여부
- Field3 (memo) — varchar(255) — 메모
- Field (created_dt) — timestamp — NOT NULL — 생성날짜
- Field2 (modified_dt) — timestamp — 수정날짜
member
- Key (member_no) — bigint — Primary key — NOT NULL — id
- Field (member_email) — varchar(100) — NOT NULL — 회원 이메일
- Field2 (member_password) — varchar(200) — NOT NULL — 회원 비밀번호
- Field5 (member_name) — varchar(50) — NOT NULL — 회원이름
- Field3 (member_signup_date) — timestamp — NOT NULL — 가입일
- Field4 (created_dt) — timestamp — 생성날짜
- Field6 (modified_dt) — timestamp — 수정날짜