mm-auth-service/sql/V5__Create_org_table.sql

16 lines
451 B
MySQL
Raw Permalink Normal View History

2025-07-25 11:00:13 +00:00
create table "organization" (
"id" char(36) not null primary key,
"name" varchar(255) not null,
"created_at" timestamp,
"updated_at" timestamp
);
comment on table "organization" is 'null';
create table "applications" (
"id" char(36) not null primary key,
"organization_id" char(36),
"name" varchar(255) not null,
"created_at" timestamp,
"updated_at" timestamp
);
comment on table "applications" is 'null';