🧩 DATABASE SCHEMA COMPARISON

[Bharani0012]

main ↔ update-drag-drop

====================================================================
TABLE: alembic_version

main & update-drag-drop:
version_num | character varying
✅ identical

====================================================================
TABLE: apikey

main & update-drag-drop:
id | uuid
name | character varying
api_key | character varying
user_id | uuid
is_active | boolean
total_uses | integer
created_at | timestamp with time zone
last_used_at | timestamp without time zone
✅ identical

====================================================================
TABLE: file

main & update-drag-drop:
id | uuid
user_id | uuid
name | character varying
path | character varying
size | integer
provider | character varying
created_at | timestamp without time zone
updated_at | timestamp without time zone
✅ identical

====================================================================
TABLE: flow

main & update-drag-drop:
id | uuid
user_id | uuid
folder_id | uuid
name | character varying
description | text
data | json
icon | character varying
icon_bg_color | character varying
endpoint_name | character varying
is_component | boolean
webhook | boolean
gradient | character varying
tags | json
locked | boolean
fs_path | character varying
access_type | USER-DEFINED
mcp_enabled | boolean
action_name | character varying
action_description | text
updated_at | timestamp without time zone
✅ identical

====================================================================
TABLE: folder

main:
id | uuid
user_id | uuid
parent_id | uuid
name | character varying
description | text

update-drag-drop:
id | uuid
user_id | uuid
parent_id | uuid
name | character varying
description | text

• auth_settings | json
  ⚠️ Difference: auth_settings (json) column added in update-drag-drop

====================================================================
TABLE: message

main & update-drag-drop:
id | uuid
flow_id | uuid
session_id | character varying
text | text
files | json
error | boolean
edit | boolean
properties | json
category | text
content_blocks | json
timestamp | timestamp without time zone
sender | character varying
sender_name | character varying
✅ identical

====================================================================
TABLE: transaction

main & update-drag-drop:
id | uuid
flow_id | uuid
vertex_id | character varying
target_id | character varying
inputs | json
outputs | json
status | character varying
error | character varying
timestamp | timestamp without time zone
✅ identical

====================================================================
TABLE: user

main & update-drag-drop:
id | uuid
username | character varying
password | character varying
is_active | boolean
is_superuser | boolean
create_at | timestamp without time zone
updated_at | timestamp without time zone
last_login_at | timestamp without time zone
profile_image | character varying
store_api_key | character varying
optins | json
✅ identical

====================================================================
TABLE: variable

main & update-drag-drop:
id | uuid
user_id | uuid
name | character varying
value | character varying
type | character varying
default_fields | json
created_at | timestamp with time zone
updated_at | timestamp with time zone
✅ identical

====================================================================
TABLE: vertex_build

main & update-drag-drop:
id | character varying
build_id | uuid
flow_id | uuid
data | json
artifacts | json
params | text
valid | boolean
timestamp | timestamp without time zone
✅ identical

====================================================================

✅ SUMMARY OF SCHEMA DIFFERENCES

====================================================================

• Added auth_settings (json) column to folder table

---

Total new columns added: 1
Affected tables: 1 (folder)
All other 9 tables are identical across both branches.