pracice2
Tables (7)
SASB
- sasb_id — VARCHAR(10) — Primary key — NOT NULL
- sasb_sector — VARCHAR(50) — NOT NULL
- sasb_industry — VARCHAR(50) — NOT NULL
Topic_subtopic
- topic_id — VARCHAR(255) — Primary key — NOT NULL
- topic — VARCHAR(255) — NOT NULL
- sub_topic — VARCHAR(255) — NOT NULL
Year
- year_id — INTEGER — Primary key — NOT NULL
- year — INTEGER — NOT NULL
company
- company_id — INTEGER — Primary key — NOT NULL
- company_name — VARCHAR(50) — NOT NULL
- sasb_id — VARCHAR(10) — NOT NULL
fact_table
- fact_id — INTEGER — NOT NULL
- company_id — INTEGER — NOT NULL
- sasb_id — VARCHAR(10) — NOT NULL
- topic_id — VARCHAR(255) — NOT NULL
- metric_id — INTEGER — NOT NULL
- unit_id — INTEGER — NOT NULL
- year_id — INTEGER — NOT NULL
- numeric_value — numeric
metric_name
- metric_id — INTEGER — Primary key — NOT NULL
- metric_name — VARCHAR(50) — NOT NULL
- topic_id — VARCHAR(255) — NOT NULL
unit
- unit_id — INTEGER — Primary key — NOT NULL
- unit_name — VARCHAR(20) — NOT NULL
- metric_id — INTEGER — NOT NULL