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