Testbed (old)

Table j4_ra_import_reports from database -testfeb25-35303837372c

Seq	Column name	Type	Max size	Null	Key
1	id	int		NO	PRI
2	date_phase1	datetime		NO
3	date_phase2	datetime		YES
4	date_completed	datetime		YES
5	method_id	int		NO
6	list_id	int		NO
7	user_id	int		NO
8	num_records	int		NO
9	num_errors	int		NO
10	num_users	int		NO
11	num_subs	int		NO
12	num_lapsed	int		NO
13	ip_address	varchar	255	YES
14	error_report	text	65535	YES
15	new_users	text	65535	YES
16	new_subs	text	65535	YES
17	lapsed_members	text	65535	YES
18	input_file	varchar	255	NO
19	created	datetime		NO
20	created_by	int		YES
21	modified	datetime		YES
22	modified_by	int		YES
23	checked_out_time	datetime		YES
24	checked_out	int		YES
25	state	tinyint		YES

25 columns in the table
Back