Meta

Tables (10)

billing_history

  • billing_history_id — bigint(20) — Primary key — NOT NULL
  • service_contract_id (service_contract_id2) — bigint(20) — Foreign key → service_contract.service_contract_id — NOT NULL
  • payment_method_id (payment_method_id2) — bigint(20) — Foreign key → service_contract.payment_method_id — NOT NULL
  • admin_id — bigint(20) — NOT NULL
  • content — varchar(100) — NOT NULL
  • created_date — datetime — NOT NULL

coupon

  • coupon_number — varchar(36) — Primary key — NOT NULL
  • type — tinyint(3) — NOT NULL
  • discount_value — int(10) — NOT NULL
  • limit_count — int(10) — NOT NULL
  • used_count — int(10) — NOT NULL

facebook_member

  • facebook_member_id — bigint(20) — Primary key — NOT NULL — 페이스북 계정 순번 PK
  • user_id — varchar(50) — NOT NULL — 페이스북 앱아이디
  • username — varchar(50) — NOT NULL — 페이스북 이름
  • access_token — varchar(255) — NOT NULL — 엑세스토큰
  • email — varchar(255) — 가입메일
  • created_date — timestamp — NOT NULL — 가입날짜
  • deleted — tinyint(1) — NOT NULL — 회원상태정보
  • last_login_date — timestamp — 마지막 로그인 일자
  • deleted_date — timestamp — 회원탈퇴일
  • service_status — varchar(100) — 서비스 상태
  • token_expire_date — timestamp — 토큰만료일

facebook_page

  • facebook_page_id — bigint(20) — Primary key — NOT NULL — 페이스북 페이지 테이블 순번값
  • page_id — varchar(50) — NOT NULL — 페이지 아이디
  • page_access_token — varchar(255) — NOT NULL — 페이지 엑세스 토큰
  • instagram_id — varchar(100) — NOT NULL — 인스타그램 아이디

page_member

  • page_member_id — bigint(20) — Primary key — NOT NULL
  • facebook_member_id (facebook_member_id2) — bigint(20) — Foreign key → facebook_member.facebook_member_id — NOT NULL — 페이스북 계정 순번 PK
  • facebook_page_id (facebook_page_id2) — bigint(20) — Foreign key → facebook_page.facebook_page_id — NOT NULL — 페이스북 페이지 테이블 순번값
  • is_leader — tinyint(1) — NOT NULL — 대표 관리자 여부
  • is_leader_request_pending — tinyint(1) — NOT NULL — 대표 관리자 양도 요청 여부
  • created_date — datetime — NOT NULL

payment

  • payment_id — varchar(20) — Primary key — NOT NULL
  • service_contract_id (service_contract_id2) — bigint(20) — Foreign key → service_contract.service_contract_id — NOT NULL
  • payment_method_id (payment_method_id2) — bigint(20) — Foreign key → service_contract.payment_method_id — NOT NULL
  • payment_frequency — varchar(20) — NOT NULL — 결제주기(1:정기,2:비정기)
  • payment_method_type — tinyint(3) — NOT NULL — 결제유형(1:신용카드)
  • payment_date — datetime
  • amount — decimal(19, 4) — NOT NULL — 결제금액
  • refund_amount — decimal(19, 4) — 환불금액
  • refund_date — datetime — 환불일자
  • status — tinyint(3) — NOT NULL — 결제상태(0:대기,1:결제완료,2:결제미납,3:환불)
  • tenant_id — bigint(20) — NOT NULL
  • receipt_url — varchar(255)
  • created_date — datetime — NOT NULL

payment_method

  • payment_method_id — bigint(20) — Primary key — NOT NULL
  • type — tinyint(4) — NOT NULL — 결제유형(1:신용카드)
  • email — varchar(255) — NOT NULL — 결제완료수신메일
  • created_date — datetime — NOT NULL

payment_method_credit_card

  • payment_method_id — bigint(20) — Foreign key → payment_method.payment_method_id — NOT NULL
  • credit_card_key — varchar(100) — NOT NULL
  • card_number — varchar(10) — NOT NULL
  • expiry — varchar(8) — NOT NULL

service_contract

  • service_contract_id — bigint(20) — Primary key — NOT NULL
  • tenant_id (tenant_id2) — int(10) — Foreign key → tenant.tenant_id — NOT NULL
  • facebook_page_id (facebook_page_id2) — bigint(20) — Foreign key → tenant.facebook_page_id — NOT NULL — 페이스북 페이지 테이블 순번값
  • payment_method_id (payment_method_id2) — bigint(20) — Foreign key → tenant.payment_method_id — NOT NULL
  • contract_type — tinyint(3) — NOT NULL — 계약유형(TRIAL, PAID)
  • contract_start_date — date — NOT NULL — 계약시작일
  • contract_end_date — date — NOT NULL — 계약종료일
  • user_count — int(10) — 컨택 사용자 수
  • contract_amount — decimal(19, 4) — 견적 금액
  • payment_method_type — tinyint(3) — NOT NULL — 결제유형(1:신용카드)
  • billing_date — date
  • billing_email — varchar(255)
  • status — tinyint(3) — NOT NULL — 계약상태(1:이용중,2:취소,3:만료)
  • created_date — datetime — NOT NULL

tenant

  • tenant_id — int(10) — Primary key — NOT NULL
  • facebook_page_id (facebook_page_id2) — bigint(20) — Foreign key → facebook_page.facebook_page_id — NOT NULL — 페이스북 페이지 테이블 순번값
  • coupon_number (coupon_number2) — varchar(36) — Foreign key → coupon.coupon_number — NOT NULL
  • payment_method_id (payment_method_id2) — bigint(20) — Foreign key → payment_method.payment_method_id — NOT NULL
  • page_id — varchar(50)
  • suspended_date — datetime — 서비스중단일시
  • terminated_date — datetime — 서비스해지일시
  • status — tinyint(3) — NOT NULL — 서비스상태(1:이용중,2:중단,3:해지)
  • created_date — datetime — NOT NULL