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 — 수정날짜