zAR-BIP-paramset-wip

efacdb_full · Custom/model/helper tables

Type

BASE TABLE

Rows est.

Size

0.02 MB

Updated

Columns

Full schema, no data mutation.

#	Name	Type	Key	Nullable	Default	Comment
1	snapshot-row-id	bigint	PRI	NO	-	-
2	paramsetid	bigint	MUL	NO	-	-
3	wona	varchar(30)	-	NO	-	-
4	wopnumber	smallint	-	NO	-	-
5	wstate	varchar(4)	-	YES	-	-
6	wqleft	double	-	NO	-	-
7	wqordered	double	-	NO	-	-
8	wqscrapped	double	-	NO	-	-
9	wqgood	double	-	NO	-	-
10	wopdsd	datetime(6)	-	NO	-	-
11	woplsd	datetime(6)	-	NO	-	-
12	wmachine	varchar(8)	-	YES	-	-
13	wskill	smallint	-	NO	-	-
14	wsettim	double	-	NO	-	-
15	wruntim	double	-	NO	-	-
16	wtrantim	double	-	NO	-	-
17	wper	smallint	-	NO	-	-
18	wdesc	varchar(255)	-	YES	-	-
19	wdrawing	varchar(14)	-	YES	-	-
20	woverlap	smallint	-	NO	-	-
21	waop	varchar(1)	-	YES	-	-
22	waltpref	smallint	-	NO	-	-
23	wqfin	double	-	NO	-	-
24	wqscrap	double	-	NO	-	-
25	wloss	double	-	NO	-	-
26	wnoprs	double	-	NO	-	-
27	wsubfixed	double	-	NO	-	-
28	wsubunit	double	-	NO	-	-
29	wnsetters	double	-	NO	-	-
30	wsetskill	smallint	-	NO	-	-
31	createdby	varchar(36)	-	YES	-	-
32	createddate	timestamp	-	YES	CURRENT_TIMESTAMP	-
33	modifiedby	varchar(36)	-	YES	-	-
34	modifieddate	datetime(6)	-	YES	-	-
35	auditoperation	varchar(8)	-	YES	-	-
36	modifiedtimestamp	binary(8)	-	NO	-	-
37	companyid	varchar(30)	-	YES	-	-
38	olversionnumber	int	-	NO	0	-
39	kitstatus	varchar(12)	-	NO	-	-
40	worksorder_partid	varchar(30)	-	YES	-	-
41	part_sm	varchar(12)	-	YES	-	-

Name	Unique	Columns
PRIMARY	Yes	snapshot-row-id
ix-zAR-BIP-paramset-wip-paramsetid	No	paramsetid

EFACS has few enforced keys; many relationships are conventional.

Column	References
No enforced foreign keys found for this table.