test

Tables (14)

chunk_bookmarks

  • id — BIGSERIAL
  • member_id — BIGINT — Foreign key → members.id — NOT NULL
  • header_chunk_id — BIGINT — Foreign key → regulation_chunks.id — NOT NULL
  • memo — TEXT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

country

  • id — BIGSERIAL
  • name_kr — VARCHAR(50) — NOT NULL
  • name_en — VARCHAR(50) — NOT NULL
  • country_code — VARCHAR(5)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

document_recent_views

  • id — BIGSERIAL
  • member_id — BIGINT — Foreign key → members.id — NOT NULL
  • document_id — BIGINT — Foreign key → regulation_documents.id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

files

  • id — BIGSERIAL
  • original_name — VARCHAR(100) — NOT NULL
  • file_url — VARCHAR(255) — NOT NULL
  • stored_name — VARCHAR(100) — NOT NULL
  • bucket — VARCHAR(30) — NOT NULL
  • content_type — VARCHAR(255) — NOT NULL
  • size — BIGINT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

members

  • id — BIGSERIAL
  • member_id — VARCHAR(20) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(10) — NOT NULL
  • department — VARCHAR(20) — NOT NULL
  • role — VARCHAR(10) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

organization

  • id — BIGSERIAL
  • name — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

refresh_tokens

  • id — BIGSERIAL
  • member_id — BIGINT — Foreign key → members.id — NOT NULL
  • token — VARCHAR(500) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • expires_at — TIMESTAMP — NOT NULL
  • revoked_at — TIMESTAMP

regulation_chunks

  • id — BIGSERIAL
  • document_id — BIGINT — Foreign key → regulation_documents.id — NOT NULL
  • contents — TEXT
  • raw_json — TEXT
  • source_element_id — VARCHAR(120) — NOT NULL
  • page_no — INTEGER — NOT NULL
  • order_index — INTEGER — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

regulation_comments

  • id — BIGSERIAL
  • document_id — BIGINT — Foreign key → regulation_documents.id — NOT NULL
  • header_chunk_id — BIGINT — Foreign key → regulation_chunks.id
  • member_id — BIGINT — Foreign key → members.id — NOT NULL
  • content — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

regulation_documents

  • id — BIGSERIAL
  • title — VARCHAR(200) — NOT NULL
  • organization_id — BIGINT — Foreign key → organization.id — NOT NULL
  • country_id — BIGINT — Foreign key → country.id — NOT NULL
  • type_id — BIGINT — Foreign key → regulation_types.id — NOT NULL
  • standard_number — VARCHAR(50) — NOT NULL
  • version — VARCHAR(20)
  • published_at — TIMESTAMP
  • file_id — BIGINT — Foreign key → files.id — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

regulation_figure_chunks

  • id — BIGINT — Foreign key → regulation_chunks.id
  • asset_id — VARCHAR(50) — NOT NULL
  • figure_type — VARCHAR(10) — NOT NULL

regulation_header_chunks

  • id — BIGINT — Foreign key → regulation_chunks.id
  • level — INTEGER — NOT NULL

regulation_text_chunks

  • id — BIGINT — Foreign key → regulation_chunks.id
  • block_type — VARCHAR(10) — NOT NULL

regulation_types

  • id — BIGSERIAL
  • type_name — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP