Manage external CFPs about gospeak HOT 1 CLOSED

CREATE TABLE external_cfps
(
    id              CHAR(36)      NOT NULL PRIMARY KEY,
    event_name      VARCHAR(120)  NOT NULL,
    event_logo      VARCHAR(1024),
    event_begin     TIMESTAMP,
    event_close     TIMESTAMP,
    event_url       VARCHAR(1024),
    description     VARCHAR(4096),
    address         VARCHAR(4096),
    address_lat     DOUBLE PRECISION,
    address_lng     DOUBLE PRECISION,
    address_country VARCHAR(30),
    tags            VARCHAR(150)  NOT NULL, -- 5 tags max
    twitter_account VARCHAR(120),
    twitter_hashtag VARCHAR(120),
    cfp_url         VARCHAR(1024) NOT NULL,
    cfp_begin       TIMESTAMP,
    cfp_close       TIMESTAMP,
    tickets_url     VARCHAR(1024),
    videos_url      VARCHAR(1024),
    created         TIMESTAMP     NOT NULL,
    created_by      CHAR(36)      NOT NULL REFERENCES users (id),
    updated         TIMESTAMP     NOT NULL,
    updated_by      CHAR(36)      NOT NULL REFERENCES users (id)
);