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