WhizVPN-ERD

Tables (16)

common_code

  • code_id — VARCHAR(50) — Primary key — NOT NULL
  • group_id — VARCHAR(50) — Foreign key → common_code_group.group_id — NOT NULL
  • code_name — VARCHAR(50) — 코드
  • code_value — TEXT
  • code_name_ko — VARCHAR(50) — 코드
  • code_name_cn — VARCHAR(50) — 코드
  • is_active — BOOLEAN
  • created_at — TIMESTAMPTZ

common_code_group

  • group_id — VARCHAR(50) — Primary key — NOT NULL
  • group_name — VARCHAR(50) — 그룹
  • group_name_ko — VARCHAR(50) — 그룹
  • group_name_cn — VARCHAR(50) — 그룹
  • is_active — BOOLEAN
  • created_at — TIMESTAMPTZ

country_code

  • country_id — INTEGER — Primary key — NOT NULL — ISO
  • country_code — VARCHAR(5) — ISO
  • country_name — VARCHAR(50) — 기본
  • country_name_ko — VARCHAR(50) — 국가
  • country_name_cn — VARCHAR(50) — 국가
  • continent_code_id — VARCHAR(50) — 대륙
  • phone_code — VARCHAR(10) — 전화
  • date_format — VARCHAR(20) — 날짜

order

  • order_id — UUID — Primary key — NOT NULL — 주문(구독)
  • uid — UUID — Foreign key → users.uid — NOT NULL — 사용자의
  • product_id — UUID — Foreign key → product_goods.product_id — NOT NULL — 상품
  • goods_id — INTEGER — Foreign key → product_goods.goods_id — NOT NULL — 판매용
  • subscription_plan — VARCHAR(50) — 구독
  • order_amount — INTEGER — 주문
  • start_date — TIMESTAMPTZ — 구독
  • end_date — TIMESTAMPTZ — 구독
  • billing_day — INTEGER — 구독
  • subscription_key — VARCHAR(50) — 구독
  • data_limit — INTEGER — 데이터
  • order_status — VARCHAR(50) — 주문
  • created_at — TIMESTAMPTZ — 등록일시

order_cancel

  • order_cancel_id — INTEGER — Primary key — NOT NULL — 주문
  • order_id — UUID — Foreign key → order.order_id — NOT NULL — 주문(구독)
  • uid — UUID — Foreign key → order.uid — NOT NULL — 사용자의
  • cancel_amount — INTEGER — 취소된
  • canceled_at — TIMESTAMPTZ — 주문

order_payment

  • payment_id — UUID — Primary key — NOT NULL — 결제
  • order_id — UUID — Foreign key → order.order_id — NOT NULL — 주문(구독)
  • uid — UUID — Foreign key → order.uid — NOT NULL — 사용자의
  • amount — INTEGER — 결제
  • currency — VARCHAR(10) — 결제
  • payment_method — VARCHAR(50) — 결제
  • status — VARCHAR(10) — 결제
  • request_at — TIMESTAMPTZ — 결제
  • approval_at — TIMESTAMPTZ — 결제
  • transaction_id — VARCHAR(100) — PG(Store)
  • pg_approval_code — VARCHAR(20) — PG
  • pg_response_message — VARCHAR(100) — PG

order_payment_log

  • payment_log_id — INTEGER — Primary key — NOT NULL — 결제
  • payment_id — UUID — Foreign key → order_payment.payment_id — NOT NULL — 결제
  • event_type — VARCHAR(50) — 결제
  • event_details — VARCHAR(200) — 세부
  • created_at — TIMESTAMPTZ — 등록

order_subscription

  • subscription_id — UUID — Primary key — NOT NULL — 구독
  • payment_id — UUID — Foreign key → order_payment.payment_id — NOT NULL — 결제
  • store_product_id — VARCHAR(50) — 스토어
  • start_date — TIMESTAMPTZ — 구독
  • end_date — TIMESTAMPTZ — 구독
  • renewal_date — TIMESTAMPTZ — 다음
  • subscription_status — VARCHAR(50) — 구독

product

  • product_id — UUID — Primary key — NOT NULL — 상품
  • product_name — VARCHAR(100) — 상품
  • product_name_ko — VARCHAR(100) — 상품
  • product_name_cn — VARCHAR(100) — 상품
  • product_type — VARCHAR(50) — 상품
  • created_at — TIMESTAMPTZ — 등록
  • updated_at — TIMESTAMPTZ — 수정

product_goods

  • goods_id — INTEGER — Primary key — NOT NULL — 판매용
  • product_id — UUID — Foreign key → product.product_id — NOT NULL — 상품
  • country_id — INTEGER — Foreign key → country_code.country_id — NOT NULL — ISO
  • goods_price — JSON — 국가별
  • contract_period — INTEGER — 약정
  • service_period — INTEGER — 서비스
  • payment_methods — JSON — 결제
  • available_data — INTEGER — 사용

user_auth

  • auth_id — INTEGER — Primary key — NOT NULL — 인증용
  • auth_key — VARCHAR(50) — Primary key — NOT NULL — 사용자
  • uid — UUID — Foreign key → users.uid — NOT NULL — 사용자의
  • user_device_id — INTEGER — Foreign key → user_device_info.user_device_id — NOT NULL — 사용자
  • auth_type — VARCHAR(50) — 인증
  • auth_token — VARCHAR(200) — 인증용
  • is_login — BOOLEAN — 로그인
  • created_at — TIMESTAMPTZ — 등록
  • updated_at — TIMESTAMPTZ — 수정

user_block_mng

  • uid — UUID — Foreign key → users.uid — NOT NULL — 사용자의
  • blocked_comment — VARCHAR(100) — 차단한
  • blocked_at — TIMESTAMPTZ — 차단된
  • reg_id — VARCHAR(100) — 등록한

user_device_info

  • user_device_id — INTEGER — Primary key — NOT NULL — 사용자
  • uid — UUID — Foreign key → users.uid — NOT NULL — 사용자의
  • device_type — VARCHAR(50) — 디바이스
  • device_model — VARCHAR(50) — 디바이스
  • device_os_version — VARCHAR(50) — 디바이스
  • device_country_code — VARCHAR(10) — 디바이스
  • device_lang_code — VARCHAR(10) — 디바이스
  • created_at — TIMESTAMPTZ
  • usage_at — TIMESTAMPTZ

users

  • uid — UUID — Primary key — NOT NULL — 사용자의
  • country_id — INTEGER — Foreign key → country_code.country_id — NOT NULL — ISO
  • email — VARCHAR(100) — 이메일
  • phone_number — VARCHAR(30) — 휴대폰
  • points_balance — INTEGER — 보유
  • user_status — VARCHAR(50) — 회원
  • potential_customer — BOOLEAN — 잠재
  • signup_at — TIMESTAMPTZ — 가입
  • created_at — TIMESTAMPTZ — 등록

vpn_client_connection

  • cid — UUID — Primary key — NOT NULL
  • sid — UUID — Foreign key → vpn_server.sid — NOT NULL — 서버의
  • uid — UUID — Foreign key → users.uid — NOT NULL — 사용자의
  • user_device_id — INTEGER — Foreign key → user_device_info.user_device_id — NOT NULL
  • protocol — VARCHAR(255) — 연결한
  • assigned_ip — VARCHAR(255) — 할당된
  • connected_at — TIMESTAMPTZ — 연결
  • disconnected_at — TIMESTAMPTZ — 연결
  • public_ip — VARCHAR(50) — 사용자의
  • use_data — INTEGER — 사용한

vpn_server

  • sid — UUID — Primary key — NOT NULL — 서버의
  • country_id — INTEGER — Foreign key → country_code.country_id — NOT NULL — ISO
  • server_name — VARCHAR(50) — 서버의
  • server_region — VARCHAR(50) — 서버의
  • geolocation — VARCHAR(50) — 위도/경도
  • server_ip — VARCHAR(30) — VPN
  • speed_limit — INTEGER — 최대
  • is_free — BOOLEAN — 무료
  • status — BOOLEAN — 서버
  • is_active — BOOLEAN — 서버
  • created_at — TIMESTAMPTZ — 등록
  • updated_at — TIMESTAMPTZ — 수정