Testbed (old)

Table j4_ra_faults from database -testfeb25-35303837372c

Seq	Column name	Type	Max size	Null	Key
1	id	int		NO	PRI
2	status_id	int		NO
3	category_code	varchar	255	YES
4	description	mediumtext	16777215	YES
5	reporter_id	int		YES
6	date_reported	datetime		YES
7	northing	varchar	255	YES
8	easting	varchar	255	YES
9	latitude	double		YES
10	longitude	float		YES
11	gridref	varchar	255	YES
12	accuracy	varchar	255	YES
13	image_name	varchar	255	YES
14	images	varchar	255	YES
15	council_ref	varchar	255	YES
16	ordering	int		YES
17	state	tinyint		YES	MUL
18	asset_id	int		NO
19	checked_out	int		YES	MUL
20	checked_out_time	datetime		YES
21	created	datetime		YES
22	created_by	int		YES	MUL
23	modified	datetime		YES
24	modified_by	int		YES	MUL
25	software_version	varchar	255	YES
26	update_link	varchar	255	YES
27	map	varchar	255	YES

27 columns in the table
Back