Print view - phpMyAdmin 4.8.4

incoming_sessions

Column	Type	Null	Default	Links to	Comments	MIME
id_session (Primary)	bigint(20)	No
id_po	bigint(20)	No		po_header -> id_po
actual_arrival_datetime	datetime	Yes	NULL
session_status	enum('OPEN', 'SUBMITTED')	No	OPEN
created_by	bigint(20)	Yes	NULL	users -> id_user
created_at	datetime	No	CURRENT_TIMESTAMP
submitted_at	datetime	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id_session	0	A	No
idx_incoming_sessions_id_po	BTREE	No	No	id_po	0	A	No
idx_incoming_sessions_status	BTREE	No	No	session_status	0	A	No
idx_incoming_sessions_arrival	BTREE	No	No	actual_arrival_datetime	0	A	Yes
idx_incoming_sessions_created_by	BTREE	No	No	created_by	0	A	Yes

incoming_session_items

Column	Type	Null	Default	Links to	Comments	MIME
id_session_item (Primary)	bigint(20)	No
id_session	bigint(20)	No		incoming_sessions -> id_session
id_item	bigint(20)	No		po_items -> id_item
qty_received	decimal(18,4)	No	0.0000

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id_session_item	0	A	No
uk_session_item	BTREE	Yes	No	id_session	0	A	No
uk_session_item	BTREE	Yes	No	id_item	0	A	No
idx_incoming_session_items_item	BTREE	No	No	id_item	0	A	No

po_header

Column	Type	Null	Default	Links to	Comments	MIME
id_po (Primary)	bigint(20)	No
no_po	varchar(30)	No
document_type	varchar(20)	Yes	NULL
vendor_no	varchar(30)	Yes	NULL
vendor_name	varchar(150)	Yes	NULL
document_date	date	Yes	NULL
posting_date	date	Yes	NULL
due_date	date	Yes	NULL
expected_receipt_date	date	Yes	NULL
purchaser_code	varchar(30)	Yes	NULL
pr_no	varchar(50)	Yes	NULL
bc_status	varchar(30)	Yes	NULL
status_po	enum('PENDING', 'PARTIAL', 'COMPLETE')	No	PENDING
created_at	datetime	No	CURRENT_TIMESTAMP

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id_po	1156	A	No
uk_purchase_orders_no_po	BTREE	Yes	No	no_po	1156	A	No
idx_po_vendor_no	BTREE	No	No	vendor_no	578	A	Yes
idx_po_expected_receipt_date	BTREE	No	No	expected_receipt_date	385	A	Yes
idx_po_status_po	BTREE	No	No	status_po	6	A	No

po_items

Column	Type	Null	Default	Links to	Comments	MIME
id_item (Primary)	bigint(20)	No
no_po	varchar(50)	Yes	NULL
line_no	int(11)	Yes	NULL
item_no	varchar(50)	Yes	NULL
description	varchar(250)	Yes	NULL
quantity	decimal(18,4)	Yes	NULL
uom_code	varchar(20)	Yes	NULL
qty_received	decimal(18,4)	No	0.0000
expected_receipt_date	date	Yes	NULL
line_status	enum('OPEN', 'PARTIAL', 'COMPLETE')	No	OPEN
created_at	datetime	No	CURRENT_TIMESTAMP

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id_item	1779	A	No
uq_po_line	BTREE	Yes	No	no_po	889	A	Yes
uq_po_line	BTREE	Yes	No	line_no	1779	A	Yes
idx_po_items_item_code	BTREE	No	No	item_no	1779	A	Yes

qc_sessions

Column	Type	Null	Default	Links to	Comments	MIME
id_qc_session (Primary)	bigint(20)	No
id_session	bigint(20)	No		incoming_sessions -> id_session
qc_datetime	datetime	Yes	NULL
qc_status	enum('PASS', 'PARTIAL', 'FULL_REJECT')	No
qc_by	bigint(20)	Yes	NULL	users -> id_user
created_at	datetime	No	CURRENT_TIMESTAMP

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id_qc_session	0	A	No
uk_qc_sessions_session	BTREE	Yes	No	id_session	0	A	No
idx_qc_sessions_qc_by	BTREE	No	No	qc_by	0	A	Yes
idx_qc_sessions_status	BTREE	No	No	qc_status	0	A	No

qc_session_items

Column	Type	Null	Default	Links to	Comments	MIME
id_qc_item (Primary)	bigint(20)	No
id_qc_session	bigint(20)	No		qc_sessions -> id_qc_session
id_session_item	bigint(20)	No		incoming_session_items -> id_session_item
qty_passed	decimal(18,4)	No	0.0000
qty_rejected	decimal(18,4)	No	0.0000

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id_qc_item	0	A	No
uk_qc_item	BTREE	Yes	No	id_qc_session	0	A	No
uk_qc_item	BTREE	Yes	No	id_session_item	0	A	No
idx_qc_session_items_session_item	BTREE	No	No	id_session_item	0	A	No

users

Column	Type	Null	Default	Links to	Comments	MIME
id_user (Primary)	bigint(20)	No
name	varchar(100)	No
email	varchar(150)	No
password_hash	varchar(255)	No
role	enum('incoming', 'qc', 'purchasing', 'dev', 'admin')	No	incoming
is_active	tinyint(1)	No	1
created_at	datetime	No	CURRENT_TIMESTAMP
updated_at	datetime	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id_user	5	A	No
uk_users_email	BTREE	Yes	No	email	5	A	No

Open new phpMyAdmin window