filein-n-out
Tables (22)
chat_messages
- idx — BIGINT — Primary key — NOT NULL
- rooms_idx — BIGINT — Foreign key → chat_rooms.idx
- users_idx — BIGINT — Foreign key → user.idx
- contents — VARCHAR(255)
- file_url — TEXT
- file_name — VARCHAR(255)
- file_type — VARCHAR(255)
- file_size — BIGINT
- message_type — VARCHAR(255) — TEXT|IMAGE|FILE|ENTER|EXIT
- created_at — DATETIME(6)
- deleted — BOOLEAN — NOT NULL
chat_participants
- idx — BIGINT — Primary key — NOT NULL
- chat_rooms_idx — BIGINT — Foreign key → chat_rooms.idx
- users_idx — BIGINT — Foreign key → user.idx
- custom_room_name — VARCHAR(255)
- is_favorite — BOOLEAN — NOT NULL
- joined_at — DATETIME(6)
- last_read_message_id — BIGINT
chat_rooms
- idx — BIGINT — Primary key — NOT NULL
- created_at — DATETIME(6)
- title — VARCHAR(255)
- last_message — VARCHAR(255)
- last_message_time — DATETIME(6)
data_transfer_ledger
- id — BIGINT — Primary key — NOT NULL
- user_idx — BIGINT — Foreign key → user.idx
- direction — VARCHAR(255) — INGRESS|EGRESS
- source — VARCHAR(255) — DRIVE_UPLOAD|WORKSPACE_UPLOAD|CHAT_UPLOAD|DRIVE_FILE|DRIVE_THUMBNAIL|DRIVE_TEXT_PREVIEW|SHARED_FILE|SHARED_THUMBNAIL|SH…
- status — VARCHAR(255) — COMPLETED|ABORTED|PARTIAL|FAILED
- bytes — BIGINT
- object_key — VARCHAR(255)
- reference_label — VARCHAR(255)
- created_at — DATETIME(6)
email_verify
- idx — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255)
- token — VARCHAR(255)
- expiry_date — DATETIME(6)
feater
- idx — BIGINT — Primary key — NOT NULL
- user_idx — BIGINT — Foreign key → user.idx — NOT NULL
- display_name — VARCHAR(100) — NOT NULL
- locale_code — VARCHAR(10) — NOT NULL
- region_code — VARCHAR(10) — NOT NULL
- marketing_opt_in — BOOLEAN — NOT NULL
- private_profile — BOOLEAN — NOT NULL
- email_notification — BOOLEAN — NOT NULL
- security_notification — BOOLEAN — NOT NULL
- profile_image_url — VARCHAR(255)
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
file_info
- idx — BIGINT — Primary key — NOT NULL
- user_idx — BIGINT — Foreign key → user.idx
- parent_idx — BIGINT — Foreign key → file_info.idx
- node_type — VARCHAR(255) — FILE|FOLDER
- file_origin_name — VARCHAR(255) — NOT NULL
- file_format — VARCHAR(255) — NOT NULL
- file_save_name — VARCHAR(255) — NOT NULL
- file_save_path — VARCHAR(255)
- file_size — BIGINT
- locked_file — BOOLEAN — NOT NULL
- shared_file — BOOLEAN — NOT NULL
- trashed — BOOLEAN
- deleted_at — DATETIME(6)
- upload_date — DATETIME(6)
- last_modify_date — DATETIME(6)
file_share
- idx — BIGINT — Primary key — NOT NULL
- file_idx — BIGINT — Foreign key → file_info.idx — NOT NULL
- owner_idx — BIGINT — Foreign key → user.idx — NOT NULL
- recipient_idx — BIGINT — Foreign key → user.idx — NOT NULL
- created_at — DATETIME(6)
notification
- idx — BIGINT — Primary key — NOT NULL
- user_idx — BIGINT — Foreign key → user.idx
- endpoint — TEXT
- p256dh — VARCHAR(255)
- auth — VARCHAR(255)
- is_active — BOOLEAN — NOT NULL
notification_list
- idx — BIGINT — Primary key — NOT NULL
- receiver_user_idx — BIGINT — Foreign key → user.idx — NOT NULL
- uuid — VARCHAR(255)
- reference_id — BIGINT
- type — VARCHAR(255) — NOT NULL
- title — VARCHAR(255) — NOT NULL
- message — TEXT
- read — BOOLEAN
- created_at — DATETIME(6) — NOT NULL
orders
- id — BIGINT — Primary key — NOT NULL
- order_id — VARCHAR(255) — NOT NULL
- payment_id — VARCHAR(255)
- user_idx — BIGINT — Foreign key → user.idx
- plan_type — VARCHAR(255)
- product_code — VARCHAR(255)
- product_name — VARCHAR(255)
- product_category — VARCHAR(255)
- billing_cycle — VARCHAR(255)
- quota_bytes — BIGINT
- expires_at — DATETIME(6)
- amount — DECIMAL(38, 2)
- create_date — DATETIME(6) — NOT NULL
- update_date — DATETIME(6) — NOT NULL
post
- post_idx — BIGINT — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- contents — LONGTEXT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6)
- type — BOOLEAN — NOT NULL
- status — INT — NOT NULL — JPA enum ordinal: 0=Private, 1=Shared, 2=Public
- uuid — VARCHAR(255) — NOT NULL
refresh_token
- id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- token — VARCHAR(512) — NOT NULL
- expiry_date — DATETIME(6) — NOT NULL
relationship
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user.idx — NOT NULL
- target_user_id — BIGINT — Foreign key → user.idx — NOT NULL
- status — VARCHAR(32) — NOT NULL — ACTIVE|BLOCKED
- created_at — DATETIME(6) — NOT NULL
relationship_group
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user.idx — NOT NULL
- name — VARCHAR(100) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
relationship_group_invite
- id — BIGINT — Primary key — NOT NULL
- group_id — BIGINT — Foreign key → relationship_group.id — NOT NULL
- from_user_id — BIGINT — Foreign key → user.idx — NOT NULL
- to_user_id — BIGINT — Foreign key → user.idx — NOT NULL
- status — VARCHAR(32) — NOT NULL — PENDING|ACCEPTED|REJECTED
- created_at — DATETIME(6) — NOT NULL
relationship_group_mapping
- id — BIGINT — Primary key — NOT NULL
- relationship_id — BIGINT — Foreign key → relationship.id — NOT NULL
- group_id — BIGINT — Foreign key → relationship_group.id
- created_at — DATETIME(6) — NOT NULL
relationship_invite
- id — BIGINT — Primary key — NOT NULL
- from_user_id — BIGINT — Foreign key → user.idx — NOT NULL
- to_user_id — BIGINT — Foreign key → user.idx
- email — VARCHAR(255)
- type — VARCHAR(32) — NOT NULL — FRIEND|WORKSPACE|GROUP|CHAT|FILE
- status — VARCHAR(32) — NOT NULL — PENDING|ACCEPTED|REJECTED
- created_at — DATETIME(6) — NOT NULL
storage_analytics_config
- id — BIGINT — Primary key — NOT NULL
- provider_capacity_bytes — BIGINT
user
- idx — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255)
- name — VARCHAR(255)
- password — VARCHAR(255)
- enable — BOOLEAN
- role — VARCHAR(255)
- account_status — VARCHAR(255) — ACTIVE|SUSPENDED|BANNED
user_post
- idx — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user.idx
- workspace_id — BIGINT — Foreign key → post.post_idx
- level — VARCHAR(255) — READ|WRITE|ADMIN
workspace_asset
- idx — BIGINT — Primary key — NOT NULL
- workspace_idx — BIGINT — Foreign key → post.post_idx — NOT NULL
- uploader_idx — BIGINT — Foreign key → user.idx — NOT NULL
- asset_type — VARCHAR(16) — NOT NULL — IMAGE|FILE
- original_name — VARCHAR(255) — NOT NULL
- stored_file_name — VARCHAR(255) — NOT NULL
- object_folder — VARCHAR(255) — NOT NULL
- object_key — VARCHAR(255) — NOT NULL
- content_type — VARCHAR(255) — NOT NULL
- file_size — BIGINT — NOT NULL
- created_at — DATETIME(6)