UDF Table Structure

1. linkis_ps_udf_baseinfo

The basic information table of udf function, which stores basic information such as udf name/type

number	name	description	type	key	empty	extra	default value
1	id	primary key auto-increment id	bigint(20)	PRI	NO	auto_increment
2	create_user	create user	varchar(50)		NO
3	udf_name	udf name	varchar(255)		NO
4	udf_type	udf type	int(11)		YES		0
5	tree_id	id of linkis_ps_udf_tree	bigint(20)		NO
6	create_time	creation time	timestamp		NO	on update CURRENT_TIMESTAMP	CURRENT_TIMESTAMP
7	update_time	update time	timestamp		NO		CURRENT_TIMESTAMP
8	sys	source system	varchar(255)		NO		ide
9	cluster_name	Cluster name, not used yet, default is all	varchar(255)		NO
10	is_expire	Expired or not	bit(1)		YES
11	is_shared	Is it shared	bit(1)		YES

udf_type

udf_type 0: udf function - generic
udf_type 2: udf function - spark

udf_type 3: custom function - python function
udf_type 4: custom function - scala function

2. linkis_ps_udf_manager

The administrator user table of the udf function, with sharing permissions, only the front end of the udf administrator has a shared entry

number	name	description	type	key	empty	extra	default value
1	id		bigint(20)	PRI	NO	auto_increment
2	user_name		varchar(20)		YES

3. linkis_ps_udf_shared_info

udf shared record table

number	name	description	type	key	empty	extra	default value
1	id		bigint(20)	PRI	NO	auto_increment
2	udf_id	id of linkis_ps_udf_baseinfo	bigint(20)		NO
3	user_name	username used by the share	varchar(50)		NO

4. linkis_ps_udf_tree

Tree-level record table for udf classification

number	name	description	type	key	empty	extra	default value
1	id		bigint(20)	PRI	NO	auto_increment
2	parent	parent category	bigint(20)		NO
3	name	Class name of the function	varchar(100)		YES
4	user_name	username	varchar(50)		NO
5	description	description information	varchar(255)		YES
6	create_time		timestamp		NO	on update CURRENT_TIMESTAMP	CURRENT_TIMESTAMP
7	update_time		timestamp		NO		CURRENT_TIMESTAMP
8	category	category distinction udf / function	varchar(50)		YES

5. linkis_ps_udf_user_load

Whether udf is the configuration loaded by default

number	name	description	type	key	empty	extra	default value
1	id		bigint(20)	PRI	NO	auto_increment
2	udf_id	id of linkis_ps_udf_baseinfo	int(11)		NO
3	user_name	user owned	varchar(50)		NO

6. linkis_ps_udf_version

udf version information table

number	name	description	type	key	empty	extra	default value
1	id		bigint(20)	PRI	NO	auto_increment
2	udf_id	id of linkis_ps_udf_baseinfo	bigint(20)		NO
3	path	The local path of the uploaded script/jar package	varchar(255)		NO
4	bml_resource_id	Material resource id in bml	varchar(50)		NO
5	bml_resource_version	bml material version	varchar(20)		NO
6	is_published	whether to publish	bit(1)		YES
7	register_format	registration format	varchar(255)		YES
8	use_format	use format	varchar(255)		YES
9	description	Version description	varchar(255)		NO
10	create_time		timestamp		NO	on update CURRENT_TIMESTAMP	CURRENT_TIMESTAMP
11	md5		varchar(100)		YES

ER diagram