I am working with the BOM (Bill of Materials) module in Oracle and have a list of tables related to this module. However, I need help understanding the following:
- Table Schema: How can I find the schema (structure) of each table, including column names, data types, and constraints?
- Data Mapping: How do I determine which table contains specific types of data related to the BOM module?
- Table Relationships: How are these tables linked with each other through primary and foreign key relationships? Is there any reference document or query that can help map the relationships?
Any guidance, including SQL queries, Oracle documentation references, or best practices to analyze these tables, would be greatly appreciated.
Thank you!