-- Interface Module: Brand_Fnd
-- Interface: Brand_In

-- Create BDI Inbound Table: BRAND_IN
-- This table is used to integrate store/location trait relationships.


CREATE TABLE BRAND_IN (
  -- bdi internal column
  bdi_seq_id NUMBER NOT NULL,
  -- bdi internal column
  bdi_app_name VARCHAR2(50) NOT NULL,
  -- bdi internal column
  bdi_dataset_type VARCHAR2(20),
  -- bdi internal column
  bdi_dataset_action VARCHAR2(20),
  -- Contains the Brand name.
  brand_name VARCHAR2(30) NOT NULL,
  -- Contains the description of the Brand.
  brand_description VARCHAR2(120) NOT NULL
);

COMMENT ON TABLE BRAND_IN IS 'This table is used to integrate store/location trait relationships.';
COMMENT ON COLUMN BRAND_IN.bdi_seq_id IS 'bdi internal column';
COMMENT ON COLUMN BRAND_IN.bdi_app_name IS 'bdi internal column';
COMMENT ON COLUMN BRAND_IN.bdi_dataset_type IS 'bdi internal column';
COMMENT ON COLUMN BRAND_IN.bdi_dataset_action IS 'bdi internal column';
COMMENT ON COLUMN BRAND_IN.brand_name IS 'Contains the Brand name.';
COMMENT ON COLUMN BRAND_IN.brand_description IS 'Contains the description of the Brand.';


-- Add BDI primary key constraint

ALTER TABLE BRAND_IN ADD CONSTRAINT pk_brand_in PRIMARY KEY (bdi_app_name, bdi_seq_id);