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