qar

Tables (19)

accounts (용도X 토큰 아직 안담김)

  • user_id (유저_id) — Foreign key → users.user_id — NOT NULL
  • account_id (계정_id) — str
  • email_verified (이메일 확인) — str
  • access_token (JWT액세스토큰) — str
  • refresh_token (JWT리프레시토큰) — str
  • expires_at (만료?) — int
  • token_type (토큰타입?)
  • scopes (?????) — str

card_blocks (Unity, Viewer 에서 Resource의 상태 정보를 저장합니다, 2D 정보를 저장합니다.)

  • card_id (카드_id) — str — Foreign key → cards.card_id — NOT NULL
  • resource_id (리소스_id) — str — Foreign key → card_resources.user_id — NOT NULL
  • card_block_id (카드블록_id) — str
  • index (???) — int

card_components (카드_컴포넌트)

  • component_id (컴포넌트_id) — 아스키코드 — Primary key — NOT NULL
  • user_id (유저_id) — str — Foreign key → users.user_id — NOT NULL

card_resources (Untitled)

  • component_id (컴포넌트_id) — 아스키코드 — Primary key — NOT NULL
  • permission_id (권한_id) — str — Primary key — NOT NULL
  • parnet_id (??) — str — Primary key — NOT NULL
  • user_id (유저_id) — str — Foreign key → card_components.user_id — NOT NULL
  • resource_id (리소스_id) — 아스키코드
  • data (데이터) — json
  • nick_name (리소스닉네임) — str

card_view_info (Untitled10)

  • card_id (카드_id) — str — Foreign key → cards.card_id — NOT NULL
  • uuid (id) — str
  • create_datetime (생성시간) — datetime
  • ip — str
  • referer (???) — str
  • agent (??) — str
  • latitude (위도) — float
  • longitude (경도) — floatc

card_visibles (3D Model의 Visible 정보를 저장합니다, 3D 의 경우 2D와 다르게 Visible 정보를 저장합니다.)

  • resource_id (리소스_id) — 아스키코드 — Foreign key → card_resources.component_id — NOT NULL
  • card_id (카드_id2) — str — Foreign key → cards.card_id — NOT NULL
  • visible (??) — bool
  • card_visible_id (카드_visible_id) — 아스키코드

cards (Untitled2)

  • card_id (카드_id) — str — Primary key — NOT NULL
  • user_id (유저_id) — str — Foreign key → users.user_id — NOT NULL
  • encrypt_id (카드_id암호화) — str — NOT NULL
  • view_count (조회수) — int
  • preview_image (프리뷰이미지) — str
  • title (제목) — str
  • view_link (뷰링크?) — str
  • qr_link (QR링크) — str
  • board_2d_size_json (????) — json
  • qr_transform_json (qr변환) — json
  • enable (Field) — bool
  • registerated_date (등록날짜) — datetime
  • edited_date (수정날짜) — datetime
  • three_js_relation (이게뭐임) — json

payment (Untitled7)

  • user_id (유저_id) — str — Foreign key → users.user_id — NOT NULL
  • product_id (물품_id) — str — Foreign key → products.product_id — NOT NULL
  • payment_id (결제수단_id) — str
  • create_date (생성시간) — datetime
  • pg (pg사) — str
  • status (상태) — str
  • quantity (구매 개수) — int
  • pay_method (결제수단) — str
  • tax_free_amount (부과세) — int
  • currency (화폐) — str
  • shedule_id (예약) — str
  • total_amount (금액) — int
  • Field (구독시작)
  • Field2 (구독만료)
  • Field

paymentfailure (결제실패)

  • user_id (유저_id) — str — Foreign key → payment.user_id — NOT NULL
  • product_id (물품_id) — str — Foreign key → payment.product_id — NOT NULL
  • error_code (오류코드) — str
  • error_message (오류 메세지) — text
  • error_type (오류 유형) — str
  • raw_response (결제 시스템 원본 응답) — str

permission_limits (Untitled5)

  • user_id (유저_id) — str — Foreign key → users.user_id — NOT NULL
  • permission_id (권한_id) — str — Foreign key → permissions.permission_id — NOT NULL
  • limit (제한) — int

permissions (Untitled3)

  • permission_id (권한_id) — str — Primary key — NOT NULL
  • permission_name (권한_이름) — str
  • description (설명) — text
  • create_date (생성일자) — datetime

product_detail (Untitled6)

  • role_id (롤_id) — int — Foreign key → roles.role_id — NOT NULL
  • product_detail_id (상품상세_id) — int
  • description (설명) — str

products (상품)

  • product_id (물품_id) — str — Primary key — NOT NULL
  • role_id (롤_id) — int — Foreign key → roles.role_id — NOT NULL
  • product_name (물품이름) — str
  • description (설명) — str
  • price (가격) — int
  • currency (화폐) — str
  • subscription_type (연,월) — str

refuned (환불)

  • Payment_id (페이먼트_id) — str — Primary key — NOT NULL
  • user_id (유저_id) — str — Foreign key → payment.user_id — NOT NULL
  • product_id (물품_id) — str — Foreign key → payment.product_id — NOT NULL
  • total_amount (상품종액) — int
  • amount (환불금액) — int
  • reason (환불사유) — str

request (Untitled8)

  • request_id (요청_id) — str — Primary key — NOT NULL
  • create_date (생성일자) — datetime
  • services (서비스) — str
  • ip — str
  • status (상태) — str

role_permissions (Untitled4)

  • role_id (롤_id) — int — Foreign key → roles.role_id — NOT NULL
  • permission_id (권한_id2) — str — Foreign key → permissions.permission_id — NOT NULL
  • assigned_at (????) — datetime
  • base_limit (기본제한) — int

roles (롤)

  • role_id (롤_id) — int — Primary key — NOT NULL
  • role_name (롤 네임) — str
  • description (설명) — text
  • grant (권한 등급) — int

tasks (Untitled9)

  • request_id (요청_id) — str — Foreign key → request.request_id — NOT NULL
  • task_id (업무_id) — str
  • create_date (생성일자) — datetime
  • status (상태) — str
  • result (결과) — str

users (유저)

  • user_id (유저_id) — str — Primary key — NOT NULL
  • product_id (제품_id)
  • email (이메일) — str
  • password (패스워드) — str
  • username (유저이름) — str
  • telephone (전화번호) — str
  • telephone_verified (전화번호확인) — bool
  • profile_image (프로필이미지) — str
  • billing_key (빌링키) — str
  • product_expiration (제품만료기한) — datetime