billing
Tables (7)
bill_department (부서)
- id — bigint — Primary key
- dept_name — varchar(100) — NOT NULL
- dept_code — varchar(50)
- parent_dept_id — bigint
- manager_id — varchar(255)
- level — int
- path — varchar(500)
- created_date — datetime
- updated_date — datetime
bill_item (아이템)
- id — bigint — Primary key
- product_item_id — int — NOT NULL
- name — varchar(255) — NOT NULL
- creator_id — varchar(255) — NOT NULL
- requester_id — varchar(255)
- billing_target — varchar(255)
- approver_id — varchar(255)
- approved_date — datetime
- created_date — datetime
- deleted_date — datetime
bill_item_billing_target_approval_history (아이템 과금 주체 설정 신청 이력)
- id — bigint — Primary key
- item_id — bigint — NOT NULL
- requester_id — varchar(255) — NOT NULL
- billing_target — varchar(50) — NOT NULL — COMPANY or DEPARTMENT
- request_reason — varchar(500) — NOT NULL — 과금 요청 사유
- action — varchar(20) — NOT NULL — REQUEST, APPROVE, REJECT
- actor_id — varchar(255) — NOT NULL — 요청자/승인자/거절자 ID
- comment — varchar(500) — archar(500) null comment '요청/승인/거절 코멘트
- requested_date — datetime — NOT NULL — 요청일시
- approved_date — datetime — 승인/거절일시
bill_item_history (아이템 사용 이력)
- id — bigint — Primary key
- item_id — bigint — NOT NULL
- status — tinyint — NOT NULL
- cpu_counts — int — NOT NULL
- memory_size — int — NOT NULL
- gpu_counts — int — NOT NULL
- gpu_memory_size — int — NOT NULL
- num_value — int — NOT NULL
- text_value — varchar(255)
- created_date — datetime
- event_date — datetime — 이벤트 발생 일시
bill_product (상품(솔루션))
- id — int — Primary key
- code — varchar(50) — NOT NULL
- name — varchar(255) — NOT NULL
- description — varchar(500)
- created_date — datetime
- deleted_date — datetime
bill_product_item (상품 아이템)
- id — int — Primary key
- product_id — int — NOT NULL
- item_type — int — NOT NULL
- item_name — varchar(255) — NOT NULL
- description — varchar(500)
- created_date — datetime
- deleted_date — datetime
bill_user (유저)
- id — varchar(255) — Primary key — NOT NULL
- username — varchar(100) — NOT NULL
- email — varchar(200)
- emp_no — varchar(20)
- dept_id — bigint
- is_manager — tinyint(1)
- role — varchar(20) — NOT NULL
- deleted_date — datetime
- created_date — datetime
- updated_date — datetime