-- Create table
CREATE TABLE NTS_RD.SERVICE_GROUP
(
  service_group_id             NUMBER NOT NULL,
  service_group_code           VARCHAR2(30) NOT NULL,
  service_group_name           VARCHAR2(127) NOT NULL,
  service_group_name2          NVARCHAR2(127),
  service_group_type           VARCHAR2(5) NOT NULL,
  description                  VARCHAR2(255),
  is_calculated_by_destination NUMBER,
  is_iskljucenje               NUMBER,
  service_group_customer_type  VARCHAR2(2),
  active                       NUMBER(1) DEFAULT 1,
  portal_visible               NUMBER(1) DEFAULT 1
)
tablespace NTS_RD
  PCTFREE 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
-- Add comments to the table
COMMENT ON TABLE NTS_RD.SERVICE_GROUP
  IS 'Group of services';
-- Add comments to the columns
COMMENT ON column NTS_RD.SERVICE_GROUP.service_group_id
  IS 'Service group identifier';
COMMENT ON column NTS_RD.SERVICE_GROUP.service_group_code
  IS 'Code of service group (organization scope).';
COMMENT ON column NTS_RD.SERVICE_GROUP.service_group_name
  IS 'The name of service group';
COMMENT ON column NTS_RD.SERVICE_GROUP.service_group_name2
  IS 'The name of service group in another language';
COMMENT ON column NTS_RD.SERVICE_GROUP.service_group_type
  IS 'Service group type identifier';
COMMENT ON column NTS_RD.SERVICE_GROUP.description
  IS 'Service group type identifier';
-- Create/Recreate primary, unique and foreign key constraints
ALTER TABLE NTS_RD.SERVICE_GROUP
  add constraint PK_SERVICE_GROUP primary key (SERVICE_GROUP_ID)
  using INDEX
  tablespace NTS_RD
  PCTFREE 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
ALTER TABLE NTS_RD.SERVICE_GROUP
  add constraint UK_SERVICE_GROUP_CODE UNIQUE (SERVICE_GROUP_CODE)
  using INDEX
  tablespace NTS_RD
  PCTFREE 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
ALTER TABLE NTS_RD.SERVICE_GROUP
  add constraint FK_SVC_GRP_SVC_GRP_TYPE foreign key (SERVICE_GROUP_TYPE)
  references NTS_RD.SERVICE_GROUP_TYPE (SERVICE_GROUP_TYPE);
-- Grant/Revoke object privileges
grant SELECT, INSERT, UPDATE, DELETE, references ON NTS_RD.SERVICE_GROUP TO NTS_INT;