carmn
Tables (15)
carmn_add_code
- id — bigint — Primary key — NOT NULL
- created_by — varchar(255)
- modified_by — varchar(255)
- reg_time — datetime(6)
- update_time — datetime(6)
- code_nm — varchar(255)
- input_type — varchar(20)
- is_use — varchar(255) — NOT NULL
- is_use_corp — varchar(255) — NOT NULL
- is_use_lease — varchar(255) — NOT NULL
- is_use_prv — varchar(255) — NOT NULL
- is_use_rent — varchar(255) — NOT NULL
- num_type — varchar(20)
- site_id — bigint — Foreign key → carmn_site.id — NOT NULL
carmn_add_sel_code
- id — bigint — Primary key — NOT NULL
- created_by — varchar(255)
- modified_by — varchar(255)
- reg_time — datetime(6)
- update_time — datetime(6)
- sel_nm — varchar(20) — NOT NULL
- add_code_id — bigint — Foreign key → carmn_add_code.id — NOT NULL
carmn_assign
- id — bigint — Primary key — NOT NULL
- created_by — varchar(255)
- modified_by — varchar(255)
- reg_time — datetime(6)
- update_time — datetime(6)
- clph_no — varchar(100) — 신청자연락처
- cntn — varchar(100) — 기타
- cust_info — varchar(100) — 목적지
- end_date — date — 배차종료일
- end_time — time — 배차종료시
- appr_yn — varchar(1) — 관리자승인여부
- stt_date — date — 배차시작일
- stt_time — time — 배차시작시
- carmn_assign_group_id — bigint — Foreign key → carmn_assign.id — 배차신청그룹
- carmn_bsc_id — bigint — Foreign key → carmn_bsc.id
- carmn_user_id — bigint — Foreign key → carmn_user.id
carmn_bsc
- id — bigint — Primary key — NOT NULL
- created_by — varchar(255)
- modified_by — varchar(255)
- reg_time — datetime(6)
- update_time — datetime(6)
- assign_type — varchar(20) — 차량배정구분
- car_no — varchar(20) — 차량번호
- car_type — varchar(100) — 차종구분
- cnrc_biz_nm — varchar(50) — 계약업체명
- cnrc_type — varchar(20) — 계약형태
- dec_yn — varchar(1) — NOT NULL — 업무승용여부
- use_yn — varchar(1) — 사용여부
- use_end_dt — date — 사용종료일
- use_stt_dt — date — 사용시작일
- site_id — bigint — Foreign key → carmn_site.id — NOT NULL
carmn_bsc_add
- id — bigint — Primary key — NOT NULL
- created_by — varchar(255)
- modified_by — varchar(255)
- reg_time — datetime(6)
- update_time — datetime(6)
- add_cd — varchar(4) — 부가정보코드
- carmn_bsc_id — bigint — Foreign key → carmn_bsc.id
carmn_bsc_rent
- id — bigint — Primary key — NOT NULL
- created_by — varchar(255)
- modified_by — varchar(255)
- reg_time — datetime(6)
- update_time — datetime(6)
- rent_amt — decimal(15, 0) — 렌트금액
- use_end_dt — date — NOT NULL — 사용종료일
- use_stt_dt — date — 사용시작일
- carmn_bsc_id — bigint — Foreign key → carmn_bsc.id
carmn_card
- id — bigint — Primary key — NOT NULL
- created_by — varchar(255)
- modified_by — varchar(255)
- reg_time — datetime(6)
- update_time — datetime(6)
- bank_cd — varchar(255)
- bank_nm — varchar(255)
- card_nick_nm — varchar(255)
- gas_card_no — varchar(20) — NOT NULL
- expr_trm — varchar(255)
- use_yn — varchar(1) — 사용여부
- issue_dt — varchar(255)
- reg_type — varchar(255)
- site_id — bigint — Foreign key → carmn_site.id — NOT NULL
carmn_card_map
- id — bigint — Primary key — NOT NULL
- created_by — varchar(255)
- modified_by — varchar(255)
- reg_time — datetime(6)
- update_time — datetime(6)
- end_dt — date
- stt_dt — date
- site_id — bigint — Foreign key → carmn_site.id — NOT NULL
- carmn_bsc_id — bigint — Foreign key → carmn_bsc.id
- carmn_card_id — bigint — Foreign key → carmn_card.id
carmn_daily_cost
- id — bigint — Primary key — NOT NULL
- created_by — varchar(255)
- modified_by — varchar(255)
- reg_time — datetime(6)
- update_time — datetime(6)
- cntn — varchar(255) — 내용
- cost_exp_amt — bigint
- cost_exp_means — int
- exp_cd — varchar(255)
- sett_yn — varchar(1) — 정산여부
- carmn_card_id — bigint — Foreign key → carmn_card.id
- carmn_daily_id — bigint — Foreign key → carmn_daily_day.id
carmn_daily_day
- id — bigint — Primary key — NOT NULL
- created_by — varchar(255)
- modified_by — varchar(255)
- reg_time — datetime(6)
- update_time — datetime(6)
- dt — date — NOT NULL — 사용일자
- use_user_name — varchar(255)
- carmn_bsc_id — bigint — Foreign key → carmn_bsc.id
- carmn_user_id — bigint — Foreign key → carmn_user.id
carmn_daily_day_drive
- id — bigint — Primary key — NOT NULL
- created_by — varchar(255)
- modified_by — varchar(255)
- reg_time — datetime(6)
- update_time — datetime(6)
- drv_af_dstn_km — bigint
- drv_bf_dstn_km — bigint
- destination — varchar(255)
- gas_type — int
- oil_lt — bigint
- oil_price — bigint
- use_type — varchar(20)
- af_photo_id — bigint — Foreign key → carmn_photo.id — 주행후사진
- bf_photo_id — bigint — Foreign key → carmn_photo.id — 주행전사진
- carmn_daily_id — bigint — Foreign key → carmn_daily_day.id
carmn_photo
- id — bigint — Primary key — NOT NULL
- created_by — varchar(255)
- modified_by — varchar(255)
- reg_time — datetime(6)
- update_time — datetime(6)
- file_idnt_id — varchar(255)
- file_nm — varchar(255)
- url — varchar(255)
carmn_site
- id — bigint — Primary key — NOT NULL
- created_by — varchar(255)
- modified_by — varchar(255)
- reg_time — datetime(6)
- update_time — datetime(6)
- biz_no — varchar(10)
- ptl_id — varchar(20)
- use_intt_id — varchar(20)
carmn_user
- id — bigint — Primary key — NOT NULL
- created_by — varchar(255)
- modified_by — varchar(255)
- reg_time — datetime(6)
- update_time — datetime(6)
- clph_no — varchar(20)
- dvsn_cd — varchar(100)
- dvsn_nm — varchar(100)
- email_id — varchar(100)
- use_yn — varchar(1) — 사용여부
- jbcl_cd — varchar(100)
- jbcl_nm — varchar(100)
- reg_type — varchar(1)
- user_nm — varchar(100)
- user_no — varchar(100) — NOT NULL
- site_id — bigint — Foreign key → carmn_site.id — NOT NULL
carmn_user_map
- id — bigint — Primary key — NOT NULL
- created_by — varchar(255)
- modified_by — varchar(255)
- reg_time — datetime(6)
- update_time — datetime(6)
- end_dt — date
- stt_dt — date
- carmn_bsc_id — bigint — Foreign key → carmn_bsc.id
- carmn_user_id — bigint — Foreign key → carmn_user.id