auto-charge
Tables (14)
BankAccount (계좌)
- id (아이디) — NN — Primary key — NOT NULL
- userId (유저아이디) — NN — Foreign key → User.id — NOT NULL
- bankCodeId (은행코드 아이디) — NN — Foreign key → BankCode.id — NOT NULL
- account (계좌번호) — NN
- balance (은행잔고) — NN
- memo (메모)
- create_at (생성날짜) — NN
- update_at (수정날짜) — NN
BankCode (은행코드)
- id (아이디) — NN — Primary key — NOT NULL
- code (은행코드) — NN
- name (은행명) — NN
- create_at (생성날짜) — NN
- update_at (수정날짜) — NN
BankMessageCount (입출금건수)
- id (아이디) — NN — Primary key — NOT NULL
- projectId (프로젝트아이디) — NN — Foreign key → Project.id — NOT NULL
- userId (유저아이디) — NN — Foreign key → Project.userId — NOT NULL
- count (개수) — NN
- time (시간) — NN
- created_at (생성시간) — NN
- updated_at (수정날짜) — NN
Calculate (정산)
- id (아이디) — NN — Primary key — NOT NULL
- projectId (프로젝트 아이디) — NN — Foreign key → Project.id — NOT NULL
- userId (유저아이디) — NN — Foreign key → Project.userId — NOT NULL
- accountId (계좌아이디) — NN — Foreign key → BankAccount.id — NOT NULL
- total (금액) — NN
- create_at (생성날짜) — NN
- update_at (수정날짜) — NN
Category (카테고리)
- id (아이디) — NN — Primary key — NOT NULL
- name (이름) — NN
- create_at (생성날짜) — NN
- update_at (수정날짜) — NN
Errors (에러)
- id (아이디) — NN — Primary key — NOT NULL
- projectId (프로젝트아이디) — NN — Foreign key → Project.id — NOT NULL
- userId (유저아이디) — NN — Foreign key → User.id — NOT NULL
- content (내용) — NN
- sender (발신자 전화번호)
- reson (이유) — NN
- create_at (생성날짜) — NN
- update_at (수정날짜) — NN
Ip (아이피)
- id (아이디) — NN — Primary key — NOT NULL
- userId (유저아이디) — NN — Foreign key → User.id — NOT NULL
- address (주소) — NN
- memo (메모)
- isActive (활성화여부) — NN
- create_at (생성날짜) — NN
- update_at (수정날짜) — NN
Message (메세지)
- id (아이디) — NN — Primary key — NOT NULL
- projectId (프로젝트아이디) — NN — Foreign key → Project.id — NOT NULL
- phoneId (핸드폰아이디) — NN — Foreign key → Phone.id — NOT NULL
- accountId (계좌아이디) — NN — Foreign key → BankAccount.id — NOT NULL
- userId (유저아이디) — NN — Foreign key → User.id — NOT NULL
- ioFlag (구분(입금, 출금))
- content (내용) — NN
- depositDate (입금,출금 날짜)
- sender (발신자 전화번호)
- amount (입금 출금 금액)
- balance (잔고)
- owner (예금주)
- isSuccessed (웹훅 데이터 전송 여부) — NN
- memo (메모)
- created_at (생성날짜) — NN
- updated_at (수정날짜) — NN
Phone (핸드폰번호)
- id (아이디) — NN — Primary key — NOT NULL
- userId (유저아이디) — NN — Foreign key → User.id — NOT NULL
- projectid (프로젝트아이디) — NN — Foreign key → Project.id — NOT NULL
- phone (핸드폰번호) — NN
- phone_name (핸드폰기종) — NN
- is_active (활성화여부) — NN
- sms_count (수신건수) — NN
- mobile_carrier (이동통신사) — NN
- created_at (생성날짜) — NN
- updated_at (수정날짜) — NN
Project (프로젝트)
- id (아이디) — NN — Primary key — NOT NULL
- userId (유저아이디) — NN — Foreign key → User.id — NOT NULL
- project_name (프로젝트이름) — NN
- is_active (활성화여부) — NN
- url — NN
- memo (메모)
- telegramChatId (채팅아이디)
- telegramToekn (토큰)
- created_at (생성날짜) — NN
- updated_at (수정날짜) — NN
Setting (세팅)
- id (아이디) — NN — Primary key — NOT NULL
- isActive (활성화 여부) — NN
- create_at (생성날짜) — NN
- update_at (수정날짜) — NN
User (유저)
- id (아이디) — NN — Primary key — NOT NULL
- signname (유저아이디) — NN
- password (비밀번호) — NN
- is_withdraw (탈퇴여부) — NN
- create_at (생성날짜) — NN
- update_at (수정날짜) — NN
- withdraw_at (탈퇴날짜) — NN
Verification (인증)
- id (아이디) — NN — Primary key — NOT NULL
- userId (유저아이디) — NN — Foreign key → User.id — NOT NULL
- type (타입) — NN
- to (받는 주소) — NN
- token (토큰) — NN
- key (키) — NN
- create_at (생성날짜) — NN
- update_at (수정날짜) — NN
tel (은행 전화번호)
- id (아이디) — NN — Primary key — NOT NULL
- code_id (은행코드 아이디) — NN — Foreign key → BankCode.id — NOT NULL
- phone (전화번호) — NN
- created_at (생성날짜) — NN
- updated_at (수정날짜) — NN