portal erd
Tables (4)
api_docs_info
- doc_id — VARCHAR(36) — Primary key — NOT NULL
- doc_name — VARCHAR(100) — NOT NULL
- title — VARCHAR(200) — NOT NULL
- description — VARCHAR(1000)
- version — VARCHAR(50)
- category — VARCHAR(100)
- spec_content — LONGTEXT
- file_path — VARCHAR(500)
- file_hash — VARCHAR(64)
- server_url — VARCHAR(500)
- status — VARCHAR(20)
- deployed_at — DATETIME
- sort_order — INT — NOT NULL
- active — TINYINT(1) — NOT NULL
- created_at — DATETIME
- created_by — VARCHAR(100)
- updated_at — DATETIME
- updated_by — VARCHAR(100)
ptl_api_guide
- id — VARCHAR(36) — Primary key — NOT NULL
- page_title — VARCHAR(200) — NOT NULL
- page_content — TEXT — NOT NULL
- guide_type — VARCHAR(20)
- display_order — INT
- use_yn — CHAR(1) — NOT NULL
- created_date — VARCHAR(14)
- created_by — VARCHAR(50)
- last_modified_date — VARCHAR(14)
- last_modified_by — VARCHAR(50)
- INDEX — idx_display_order
- INDEX — idx_use_yn
- INDEX — idx_guide_type
ptl_system_identifier
- system_code — VARCHAR(20) — Primary key — NOT NULL
- description — VARCHAR(200) — NOT NULL
- prefix — VARCHAR(10)
- identifier_length — INT
- start_number — INT
- next_sequence — INT
- auto_generate_yn — VARCHAR(1) — NOT NULL
- use_yn — VARCHAR(1) — NOT NULL
- created_date — VARCHAR(14)
- created_by — VARCHAR(50)
- last_modified_date — VARCHAR(14)
- last_modified_by — VARCHAR(50)
ptl_system_identifier_org
- system_code — VARCHAR(20) — Primary key — NOT NULL
- org_id — VARCHAR(36) — Primary key — NOT NULL
- identifier — VARCHAR(50) — NOT NULL
- use_yn — VARCHAR(1) — NOT NULL
- created_date — VARCHAR(14)
- created_by — VARCHAR(50)
- last_modified_date — VARCHAR(14)
- last_modified_by — VARCHAR(50)