DEFINE TABLE role SCHEMAFULL;

DEFINE FIELD name ON TABLE role TYPE string;
DEFINE FIELD permissions ON TABLE role TYPE array<string>;
DEFINE FIELD created_at ON TABLE role TYPE datetime VALUE time::now() READONLY;
DEFINE FIELD updated_at ON TABLE role TYPE datetime VALUE time::now();

DEFINE INDEX roleName ON TABLE user COLUMNS name UNIQUE;