테스트

테이블 (21)

agent

  • agent_id — int — NOT NULL

agent_tenant_mapping

  • agent_tenant_mapping_id — int — NOT NULL
  • agent_id — int — NOT NULL
  • tenant_id — int — NOT NULL

code

  • id — int — NOT NULL

file

  • file_id — int — NOT NULL
  • path — varchar — NOT NULL

file_mapping

  • file_mapping_id — int — NOT NULL
  • file_id — int — NOT NULL
  • id2 — int — NOT NULL

payment_log

  • payment_log_id — int — NOT NULL
  • tenant_id — int — NOT NULL
  • payment_product_id — int — NOT NULL — 결제상품PK

payment_product

  • payment_product_id — int — NOT NULL — 결제상품PK
  • product_name — varchar — 상품명
  • product_price — bigint — NOT NULL — 상품가격

payments

  • id — int — NOT NULL
  • Field — VARCHAR(255)

pymn_prdc_agnt_mpng

  • id — int — NOT NULL
  • payment_product_id — int — NOT NULL — 결제상품PK
  • agent_id2 — int — NOT NULL — agent id mapping key
  • Field — VARCHAR(255)

tenant

  • tenant_id — int — NOT NULL

tenant_api_key

  • id — int — NOT NULL
  • tenant_id — int — NOT NULL
  • active — boolean — 요율 사용여부
  • Field — VARCHAR(255)

tenant_auth

  • id — int — NOT NULL
  • tenant_id — int — NOT NULL
  • auth — varchar — NOT NULL

tenant_auth_mapping

  • tenant_auth_mapping_id — int — NOT NULL
  • user_id — int — NOT NULL
  • tenant_auth_id — int — NOT NULL

tenant_points

  • id — int — NOT NULL
  • tenant_id — int — NOT NULL
  • total_point — int — NOT NULL
  • update_date — VARCHAR(255)

tenant_points_transaction

  • id — int — NOT NULL
  • tenant_id — int — NOT NULL
  • id2 — int — NOT NULL
  • amount — int — NOT NULL
  • type — enum — NOT NULL — 'CHARGE', 'USE
  • ADJUST, — `reason`

tenant_rates

  • id — int — NOT NULL
  • tenant_id — int — NOT NULL
  • active — boolean — 요율 사용여부

tool

  • tool_id — int — NOT NULL

tool_tenant_mapping

  • tool_tenant_mapping_id — int — NOT NULL
  • tool_id2 — int — NOT NULL
  • tenant_id — int — NOT NULL

user

  • id — int — NOT NULL
  • tenant_id — int — NOT NULL

user_auth

  • user_auth_id — int — NOT NULL
  • user_auth_name — varchar — NOT NULL

user_auth_mapping

  • user_auth_mapping_id — int — NOT NULL
  • user_id — int — NOT NULL
  • user_auth_id — int — NOT NULL