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