Testbed (old)

Table j4_ra_enhancements from database -testfeb25-35303837372c

Seq	Column name	Type	Max size	Null	Key
1	id	int		NO	PRI
2	state	tinyint		YES	MUL
3	group_code	text	65535	YES
4	date_completed	datetime		YES
5	type	varchar	255	YES
6	parish	varchar	255	YES
7	team	varchar	255	YES
8	description	text	65535	YES
9	attachment	text	65535	YES
10	gridref	varchar	255	YES
11	latitude	float		YES
12	longitude	float		YES
13	easting	int		YES
14	northing	int		YES
15	checked_out	int		YES	MUL
16	checked_out_time	datetime		YES
17	created_by	int		YES	MUL
18	modified_by	int		YES	MUL

18 columns in the table
Back