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)