beacon_actions.tbl

--------------------------------------------------------
--  File created - Tuesday-September-12-2017
--------------------------------------------------------
WHENEVER SQLERROR EXIT
--------------------------------------------------------
--  DDL for Table ACTIONS
--------------------------------------------------------

CREATE TABLE "BEACON"."ACTIONS" (
    "ID"       NUMBER
        GENERATED BY DEFAULT ON NULL AS IDENTITY,
    "ACTION"   VARCHAR2(100),
    "VALUE"    VARCHAR2(100)
);

COMMENT ON COLUMN "BEACON"."ACTIONS"."ACTION" IS
    'Function to run';

COMMENT ON COLUMN "BEACON"."ACTIONS"."VALUE" IS
    'Value passed to function';
--------------------------------------------------------
--  DDL for Index ACTIONS_PK
--------------------------------------------------------

CREATE UNIQUE INDEX "BEACON"."ACTIONS_PK" ON
    "BEACON"."ACTIONS" ( "ID" );
    
--------------------------------------------------------
--  Constraints for Table ACTIONS
--------------------------------------------------------

ALTER TABLE "BEACON"."ACTIONS" MODIFY (
    "ACTION"
        NOT NULL ENABLE
);

ALTER TABLE "BEACON"."ACTIONS" ADD 
    CONSTRAINT "ACTIONS_PK" PRIMARY KEY ( "ID" )
        USING INDEX actions_pk
    ENABLE VALIDATE;