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