苹果CMSV10 mac_actor数据表介绍

2025-02-20 共人阅读

序号	列名	数据类型	长度	小数位数	主键	自增	允许空	默认值	列说明
1	actor_id	int			√	√
2	type_id	smallint		0				0
3	type_id_1	smallint		0				0
4	actor_name	varchar	255
5	actor_en	varchar	255
6	actor_alias	varchar	255
7	actor_status	tinyint		0				0
8	actor_lock	tinyint		0				0
9	actor_letter	char	1
10	actor_sex	char	1
11	actor_color	varchar	6
12	actor_pic	varchar	1024
13	actor_blurb	varchar	255
14	actor_remarks	varchar	100
15	actor_area	varchar	20
16	actor_height	varchar	10
17	actor_weight	varchar	10
18	actor_birthday	varchar	10
19	actor_birtharea	varchar	20
20	actor_blood	varchar	10
21	actor_starsign	varchar	10
22	actor_school	varchar	20
23	actor_works	varchar	255
24	actor_tag	varchar	255
25	actor_class	varchar	255
26	actor_level	tinyint		0				0
27	actor_time	int						0
28	actor_time_add	int						0
29	actor_time_hits	int						0
30	actor_time_make	int						0
31	actor_hits	mediumint		0				0
32	actor_hits_day	mediumint		0				0
33	actor_hits_week	mediumint		0				0
34	actor_hits_month	mediumint		0				0
35	actor_score	decimal	3	1				0.0
36	actor_score_all	mediumint		0				0
37	actor_score_num	mediumint		0				0
38	actor_up	mediumint		0				0
39	actor_down	mediumint		0				0
40	actor_tpl	varchar	30
41	actor_jumpurl	varchar	150
42	actor_content	text	65535