테스트
테이블 (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
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_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