S5 — ระบบค่าตอบแทนทนายความ (134/1) — Data Dictionary¶

LEGACY DB — ยังไม่ได้ย้ายเข้า Single DB

ระบบเดิมบนเครื่อง legacy (10.136.27.43 / DB rlpd_134) — ยังไม่ migrate เข้า PSDBPRDDB (10.136.27.149). ดู Legacy DB Inventory

ทุกตาราง/ทุกคอลัมน์ (โครงสร้างจาก live DB). กลับ ภาพรวม · machine-readable: schema.json

`CI_Sessions`¶

Column	Data Type	Constraints
session_id	nvarchar(40)	PK, DEFAULT '0'
ip_address	nvarchar(16)	DEFAULT '0', NOT NULL
user_agent	nvarchar(120)	NOT NULL
last_activity	int	DEFAULT 0, NOT NULL
user_data	text	NOT NULL

`approval`¶

Column	Data Type	Constraints
id	int	PK, IDENTITY
code	nvarchar(50)
cases	nvarchar(max)
amount	decimal(18,2)
sign_name1	nvarchar(250)
sign_name2	nvarchar(250)
sign_name3	nvarchar(250)
pay_code	nvarchar(50)
approve_po_date	date
approve_date	date
cheque	nvarchar(50)
tranfer_date	date
statuss	nvarchar(50)
date_add	date
deleted	int
amount_otw	float
nitikorn_id	nvarchar(100)

`area`¶

Column	Data Type	Constraints
id	int	PK, IDENTITY
zone_id	int	NOT NULL
name	nvarchar(150)	NOT NULL
date_add	datetime	NOT NULL
date_update	datetime	NOT NULL
deleted	int	NOT NULL
province_id	int

`case_history`¶

Column	Data Type	Constraints
case_history_id	int	PK, IDENTITY
rlpd_doc_receive_date	date
doc_register_date	date
province	nvarchar(255)
doc_order_no	nvarchar(10)
doc_receive_date	date
case_type_id	nvarchar(255)
province_abbreviation	nvarchar(255)
doc_receive_no	nvarchar(255)
doc_receive_year	nvarchar(10)
lawyer_title	nvarchar(255)
lawyer_name	nvarchar(255)
lawyer_lastname	nvarchar(255)
lawyer_license_no	nvarchar(255)
lawyer_personal_id	nvarchar(255)
account_no	nvarchar(255)
bank_name	nvarchar(255)
lawyer_tel_no	nvarchar(255)
accused_title	nvarchar(255)
accused_name	nvarchar(255)
accused_lastname	nvarchar(255)
number_of_accused	nvarchar(255)
accused_age	nvarchar(10)
accused_personal_id	nvarchar(20)
charge_detail	nvarchar(max)
provincail_police_station_name	nvarchar(255)
capital_police_station_name	nvarchar(255)
special_dept_police_station	nvarchar(200)
investigate_date	date
investigate_time	nvarchar(50)
sue_flag	char(1)
notsue_flag	char(1)
sue_date	date
black_case_no	nvarchar(255)
court_name	nvarchar(255)
case_type_1_flag	char(1)
case_type_2_flag	char(1)
case_type_3_flag	char(1)
case_type_4_flag	char(1)
cost_of_travel	numeric(10,2)
cost_of_lodging	numeric(10,2)
allowance	int
total_offsite_cost	numeric(10,2)
doc_sign_date	date
doc_check_date	date
step_one_total_day	int
step_one_intime_flag	char(1)
step_one_late_flag	char(1)
doc_complete_flag	char(1)
doc_incomplete_flag	char(1)
doc_sendback_flag	char(1)
doc_repeat_flag	char(1)
remark	nvarchar(255)
process_complete	nvarchar(255)
officer_name	nvarchar(255)
leader_assign_date	date
rlpd_lawyer_comment_date	date
delivery_to_leader_date	date
leader_check_date	date
delivery_to_director_date	date
payment_approval_no	nvarchar(255)
payment_approval_date	date
step_two_total_day	int
step_two_intime_flag	char(1)
step_two_late_flag	char(1)
general_director_approve_date	date
step_three_total_day	int
step_three_intime_flag	char(1)
step_three_late_flag	char(1)
approve_date	date
bank_transfer_date	date
withdraw_no	nvarchar(255)
lawyer_notice_doc_no	nchar(255)
lawyer_notice_date	date
step_four_total_day	int
step_four_intime_flag	char(1)
step_four_late_flag	char(1)
standard_total_day	int
standard_intime_flag	char(1)
standard_late_flag	char(1)

`case_type`¶

Column	Data Type	Constraints
id	int	PK, IDENTITY
name	nvarchar(900)	NOT NULL
value	int
date_add	datetime	NOT NULL
date_update	datetime	NOT NULL
deleted	int	NOT NULL

`cases`¶

Column	Data Type	Constraints
id	int	PK, IDENTITY
case_cat	nvarchar(50)
request_number	nvarchar(50)
locat	int
locat_name	nvarchar(150)
wdate	date
sue	nvarchar(50)
black_case	nvarchar(150)
court	int
court_name	nvarchar(150)
sue_date	date
prosecutor_office	int
prosecutor_office_name	nvarchar(150)
not_sue_date	date
lawyer_personal_id	nvarchar(13)	NOT NULL
lawyer_lvl	nvarchar(150)
allowed	nvarchar(150)
work_years	nvarchar(50)
work_date	date
suspect	nvarchar(max)
case_type	int
case_type_name	nvarchar(150)
wrong_type	int
wrong_type_name	nvarchar(150)
case_detail	text
zone_id	int
zone_name	nvarchar(150)
area_id	int
area_name	nvarchar(250)
police_station	int
police_station_name	nvarchar(250)
inquiry_official	nvarchar(200)
doc1	nvarchar(150)
doc2	nvarchar(150)
date_add	datetime
date_update	datetime
case_status	nvarchar(150)
deleted	int
nitikorn_personal_id	nvarchar(13)
comment	text
amount	float
budget_type	nvarchar(50)
note	text
manager_comment	text
manager_approve	nvarchar(50)
bounce_note	text
all_doc	nvarchar(250)
refund_file	nvarchar(250)
refund_detail	text
stamp_date1	date
stamp_date2	date
stamp_date3	date
stamp_date4	date
stamp_date5	date
countcase	nvarchar(50)
case_detail_otw	text
case_otw	float
amount_otw	float
stamp_date6	date

`db_owner.case_his_new`¶

Column	Data Type	Constraints	Description
case_history_id	int	PK, IDENTITY
case_name	nchar(10)

`db_owner.court`¶

Column	Data Type	Constraints
id	int	PK, IDENTITY
name	nvarchar(150)
date_add	datetime
date_update	datetime
deleted	int

`db_owner.yearbudget`¶

Column	Data Type	Constraints
yb_id	int	PK, IDENTITY
yb_year	int
yb_count	int
yb_status	int

`db_owner.yearbudgetadult`¶

Column	Data Type	Constraints
yba_id	int	PK, IDENTITY
yba_year	int
yba_count	int
yba_status	int

`geo_provinces`¶

Column	Data Type	Constraints
province_id	int	PK
province_code	varchar(2)	NOT NULL
province_name	varchar(150)	NOT NULL
province_name_en	varchar(150)	NOT NULL
geo_id	int	DEFAULT 0, NOT NULL
zone_name	varchar(150)

`lawyer`¶

Column	Data Type	Constraints
id	int	PK, IDENTITY
personal_id	bigint
tel	nvarchar(10)
email	nvarchar(50)
address	text
zone_id	int
area_id	int
date_add	datetime
date_update	datetime
deleted	int
prefix	nvarchar(150)
name	nvarchar(max)
lastname	nvarchar(150)
license	nvarchar(max)

`lawyer_131167`¶

Column	Data Type	Constraints
id	int	PK, IDENTITY
personal_id	bigint
tel	nvarchar(10)
email	nvarchar(50)
address	text
zone_id	int
area_id	int
date_add	datetime
date_update	datetime
deleted	int
prefix	nvarchar(150)
name	nvarchar(max)
lastname	nvarchar(150)
license	nvarchar(max)

`lawyer_bk`¶

Column	Data Type	Constraints
id	int	PK, IDENTITY
personal_id	bigint
tel	nvarchar(10)
email	nvarchar(50)
address	text
zone_id	int
area_id	int
date_add	datetime
date_update	datetime
deleted	int
prefix	nvarchar(150)
name	nvarchar(max)
lastname	nvarchar(150)
license	nvarchar(max)

`lawyer_youth`¶

Column	Data Type	Constraints
id	int	IDENTITY, NOT NULL
personal_id	bigint
prefix	nvarchar(150)
name	nvarchar(200)
lastname	nvarchar(150)
tel	nvarchar(10)
email	nvarchar(50)
address	text
license	nvarchar(50)
zone_id	int
area_id	int
date_add	datetime
date_update	datetime
deleted	int

`lawyer_youth_bk`¶

Column	Data Type	Constraints
id	int	PK, IDENTITY
personal_id	bigint
prefix	nvarchar(150)
name	nvarchar(200)
lastname	nvarchar(150)
tel	nvarchar(10)
email	nvarchar(50)
address	text
license	nvarchar(50)
zone_id	int
area_id	int
date_add	datetime
date_update	datetime
deleted	int

`log`¶

Column	Data Type	Constraints
id	int	PK, IDENTITY
menu	nvarchar(50)
action_id	bigint
action_detail	nvarchar(max)
action	nvarchar(50)
date	datetime

`office`¶

Column	Data Type	Constraints
id	int	PK, IDENTITY
name	nvarchar(300)
date_add	datetime
date_update	datetime
deleted	int
province_id	int
sname	nvarchar(50)
syear	int
snumber	int
snumber75	int

`police_station`¶

Column	Data Type	Constraints
id	int	PK, IDENTITY
zone_id	int	NOT NULL
area_id	int	NOT NULL
name	nvarchar(150)	NOT NULL
date_add	datetime	NOT NULL
date_update	datetime	NOT NULL
deleted	int	NOT NULL

`register`¶

Column	Data Type	Constraints
personal_id	bigint	PK
menu	nvarchar(400)
prefix	nvarchar(150)
name	nvarchar(150)
lastname	nvarchar(150)
email	nvarchar(50)
license_youth	nvarchar(50)
tel	nvarchar(10)
token	int
password	nvarchar(50)
address	nvarchar(250)
bank	nvarchar(50)
acc_no	nvarchar(20)
enable	int
date_add	datetime
date_update	datetime
deleted	int
locat	int
employee_code	nvarchar(50)
tel2	nvarchar(100)
license	nvarchar(max)
register_type	nvarchar(50)

`register_copy1`¶

Column	Data Type	Constraints
personal_id	bigint	PK
menu	nvarchar(400)
prefix	nvarchar(150)
name	nvarchar(150)
lastname	nvarchar(150)
email	nvarchar(50)
license_youth	nvarchar(50)
tel	nvarchar(10)
token	int
password	nvarchar(50)
address	nvarchar(250)
bank	nvarchar(50)
acc_no	nvarchar(20)
enable	int
date_add	datetime
date_update	datetime
deleted	int
locat	int
employee_code	nvarchar(50)
tel2	nvarchar(100)
license	nvarchar(max)
register_type	nvarchar(50)

`register_copy2`¶

Column	Data Type	Constraints
personal_id	bigint	PK
menu	nvarchar(400)
prefix	nvarchar(150)
name	nvarchar(150)
lastname	nvarchar(150)
email	nvarchar(50)
license_youth	nvarchar(50)
tel	nvarchar(10)
token	int
password	nvarchar(50)
address	nvarchar(250)
bank	nvarchar(50)
acc_no	nvarchar(20)
enable	int
date_add	datetime
date_update	datetime
deleted	int
locat	int
employee_code	nvarchar(50)
tel2	nvarchar(100)
license	nvarchar(max)
register_type	nvarchar(50)

`settingtime`¶

Column	Data Type	Constraints	Description
ST_id	int	PK
ST_step1	int		wait approve document
ST_step2	int		comment to boss
ST_step3	int		pay result
ST_add	datetime
ST_useradd	varchar(255)
ST_day	int		limit day after work
ST_75day	int		limit day after work
ST_step4	int		pay result

`suspect`¶

Column	Data Type	Constraints
id	int	PK, IDENTITY
case_id	int
pid	nvarchar(250)
prefix	nvarchar(250)
name	nvarchar(250)
lastname	nvarchar(250)
years_old	nvarchar(250)
years_old_at	nvarchar(250)
gender	nvarchar(250)
country	nvarchar(250)
deleted	int

`sysdiagrams`¶

Column	Data Type	Constraints
name	sysname	NOT NULL
principal_id	int	NOT NULL
diagram_id	int	PK, IDENTITY
version	int
definition	varbinary(max)

`travel`¶

Column	Data Type	Constraints
id	int	PK, IDENTITY
case_id	int
start_date	date
end_date	date
days	int
locat	nvarchar(250)
travel_by	nvarchar(250)
fare	int
hotel	int
etc	int
deleted	int

`wrong_type`¶

Column	Data Type	Constraints
id	int	PK, IDENTITY
name	nvarchar(250)
date_add	datetime
date_update	datetime
deleted	int

`zone`¶

Column	Data Type	Constraints
id	int	PK, IDENTITY
name	nvarchar(150)	NOT NULL
date_add	datetime	NOT NULL
date_update	datetime	NOT NULL
deleted	int	NOT NULL

`zone_province`¶

Column	Data Type	Constraints
zone_id	int	PK, IDENTITY
zone_name_en	nvarchar(150)
zone_name_th	nvarchar(150)
date_add	datetime
date_update	datetime

S5 — ระบบค่าตอบแทนทนายความ (134/1) — Data Dictionary¶

CI_Sessions¶

approval¶

area¶

case_history¶

case_type¶

cases¶

db_owner.case_his_new¶

db_owner.court¶

db_owner.yearbudget¶

db_owner.yearbudgetadult¶

geo_provinces¶

lawyer¶

lawyer_131167¶

lawyer_bk¶

lawyer_youth¶

lawyer_youth_bk¶

log¶

office¶

police_station¶

register¶

register_copy1¶

register_copy2¶

settingtime¶

suspect¶

sysdiagrams¶

travel¶

wrong_type¶

zone¶

zone_province¶

`CI_Sessions`¶

`approval`¶

`area`¶

`case_history`¶

`case_type`¶

`cases`¶

`db_owner.case_his_new`¶

`db_owner.court`¶

`db_owner.yearbudget`¶

`db_owner.yearbudgetadult`¶

`geo_provinces`¶

`lawyer`¶

`lawyer_131167`¶

`lawyer_bk`¶

`lawyer_youth`¶

`lawyer_youth_bk`¶

`log`¶

`office`¶

`police_station`¶

`register`¶

`register_copy1`¶

`register_copy2`¶

`settingtime`¶

`suspect`¶

`sysdiagrams`¶

`travel`¶

`wrong_type`¶

`zone`¶

`zone_province`¶