machines

efacdb_full · Live EFACS mirror

Type

BASE TABLE

Rows est.

Size

0.08 MB

Updated

2026-03-19 20:51:55

Columns

Full schema, no data mutation.

#	Name	Type	Key	Nullable	Default	Comment
1	macid	varchar(8)	PRI	NO	-	-
2	macdesc	varchar(30)	-	YES	-	-
3	macfac	double	-	NO	-	-
4	macshift	smallint	-	NO	-	-
5	machol	smallint	-	NO	-	-
6	macnum	smallint	-	NO	-	-
7	msection	varchar(8)	-	YES	-	-
8	machrate	double	-	NO	-	-
9	msrate	double	-	NO	-	-
10	morate	double	-	NO	-	-
11	machratesell	double	-	NO	-	-
12	msratesell	double	-	NO	-	-
13	moratesell	double	-	NO	-	-
14	mcosthead	varchar(8)	-	YES	-	-
15	msovhead	double	-	NO	-	-
16	moovhead	double	-	NO	-	-
17	mmovhead	double	-	NO	-	-
18	msovheadsell	double	-	NO	-	-
19	moovheadsell	double	-	NO	-	-
20	mmovheadsell	double	-	NO	-	-
21	mohcosthead	varchar(8)	-	YES	-	-
22	machfsrate	double	-	NO	-	-
23	msfsrate	double	-	NO	-	-
24	mofsrate	double	-	NO	-	-
25	msfsovhead	double	-	NO	-	-
26	mofsovhead	double	-	NO	-	-
27	mmfsovhead	double	-	NO	-	-
28	machgtrate	double	-	NO	-	-
29	msgtrate	double	-	NO	-	-
30	mogtrate	double	-	NO	-	-
31	msgtovhead	double	-	NO	-	-
32	mogtovhead	double	-	NO	-	-
33	mmgtovhead	double	-	NO	-	-
34	createdby	varchar(36)	-	YES	-	-
35	createddate	timestamp	-	YES	CURRENT_TIMESTAMP	-
36	modifiedby	varchar(36)	-	YES	-	-
37	modifieddate	datetime(6)	-	YES	-	-
38	auditoperation	varchar(8)	-	YES	-	-
39	modifiedtimestamp	binary(8)	-	NO	-	-
40	iscapacity	tinyint(1)	-	NO	0	-
41	istime	tinyint(1)	-	NO	0	-
42	isplanning	tinyint(1)	-	NO	0	-
43	companyid	varchar(30)	-	YES	-	-
44	olversionnumber	int	-	NO	0	-
45	isindividualitembooked	tinyint(1)	-	NO	-	-
46	uuid	varchar(36)	UNI	NO	-	-

Name	Unique	Columns
PRIMARY	Yes	macid
uq_machines_uuid	Yes	uuid

EFACS has few enforced keys; many relationships are conventional.

Column	References
No enforced foreign keys found for this table.