더 숲
테이블 (14)
accounts_user
- id — BIGSERIAL
- password — VARCHAR(128) — NOT NULL
- last_login — TIMESTAMPTZ
- is_superuser — BOOLEAN — NOT NULL
- email — VARCHAR(254) — NOT NULL
- firebase_uid — VARCHAR(128)
- name — VARCHAR(100) — NOT NULL
- phone_number — VARCHAR(20) — NOT NULL
- department — VARCHAR(32) — NOT NULL
- approval_status — VARCHAR(20) — NOT NULL
- is_active — BOOLEAN — NOT NULL
- is_staff — BOOLEAN — NOT NULL
- date_joined — TIMESTAMPTZ — NOT NULL
constructions_constructionhistory
- id — BIGSERIAL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- construction_id — BIGINT — 외래 키 → projects_construction.id — NOT NULL
- text — TEXT — NOT NULL
- file_url — VARCHAR(2048) — NOT NULL
- file_type — VARCHAR(40) — NOT NULL
- object_key — VARCHAR(1024) — NOT NULL
- original_name — VARCHAR(255) — NOT NULL
- content_type — VARCHAR(128) — NOT NULL
- size — BIGINT
- uploaded_by_id — BIGINT — 외래 키 → accounts_user.id
constructions_constructionmanagerassignment
- id — BIGSERIAL
- assigned_at — TIMESTAMPTZ — NOT NULL
- construction_id — BIGINT — 외래 키 → projects_construction.id — NOT NULL
- user_id — BIGINT — 외래 키 → accounts_user.id — NOT NULL
designs_designhistory
- id — BIGSERIAL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- design_id — BIGINT — 외래 키 → projects_design.id — NOT NULL
- text — TEXT — NOT NULL
- file_url — VARCHAR(2048) — NOT NULL
- file_type — VARCHAR(40) — NOT NULL
- object_key — VARCHAR(1024) — NOT NULL
- original_name — VARCHAR(255) — NOT NULL
- content_type — VARCHAR(128) — NOT NULL
- size — BIGINT
- uploaded_by_id — BIGINT — 외래 키 → accounts_user.id
designs_designmanagerassignment
- id — BIGSERIAL
- assigned_at — TIMESTAMPTZ — NOT NULL
- design_id — BIGINT — 외래 키 → projects_design.id — NOT NULL
- user_id — BIGINT — 외래 키 → accounts_user.id — NOT NULL
inquiries_inquiry
- id — BIGSERIAL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- name — VARCHAR(100) — NOT NULL
- contact_number — VARCHAR(20) — NOT NULL
- company_name — VARCHAR(200) — NOT NULL
- business_fields — JSONB — NOT NULL
- email — VARCHAR(254) — NOT NULL
- project_name_and_address — VARCHAR(500) — NOT NULL
- discovery_channels — JSONB — NOT NULL
- request_scopes — JSONB — NOT NULL
- request_spaces — JSONB — NOT NULL
- area_range — VARCHAR(20) — NOT NULL
- budget_range — VARCHAR(20) — NOT NULL
- reception_channel — VARCHAR(20) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- content — TEXT — NOT NULL
- project_id — BIGINT — 외래 키 → projects_project.id
inquiries_inquiryconsultation
- id — BIGSERIAL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- inquiry_id — BIGINT — 외래 키 → inquiries_inquiry.id — NOT NULL
- content — TEXT — NOT NULL
- consulted_at — TIMESTAMPTZ
- channel — VARCHAR(20) — NOT NULL
- recorded_by_id — BIGINT — 외래 키 → accounts_user.id
inquiries_inquirymanagerassignment
- id — BIGSERIAL
- inquiry_id — BIGINT — 외래 키 → inquiries_inquiry.id — NOT NULL
- manager_id — BIGINT — 외래 키 → accounts_user.id — NOT NULL
- assigned_at — TIMESTAMPTZ — NOT NULL
projects_construction
- id — BIGSERIAL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- project_id — BIGINT — 외래 키 → projects_project.id — NOT NULL
projects_constructionquotation
- id — BIGSERIAL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- history_id — BIGINT — 외래 키 → constructions_constructionhistory.id — NOT NULL
- metadata — JSONB — NOT NULL
projects_design
- id — BIGSERIAL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- project_id — BIGINT — 외래 키 → projects_project.id — NOT NULL
projects_designquotation
- id — BIGSERIAL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- design_id — BIGINT — 외래 키 → projects_design.id — NOT NULL
- recipient_name — VARCHAR(100) — NOT NULL
- recipient_position — VARCHAR(100) — NOT NULL
- recipient_contact — VARCHAR(50) — NOT NULL
- recipient_email — VARCHAR(254) — NOT NULL
- sender_name — VARCHAR(100) — NOT NULL
- sender_position — VARCHAR(100) — NOT NULL
- sender_contact — VARCHAR(50) — NOT NULL
- sender_email — VARCHAR(254) — NOT NULL
- quotation_date — DATE
- site_location — VARCHAR(500) — NOT NULL
- design_area — JSONB — NOT NULL
- design_scope — JSONB — NOT NULL
- design_period — JSONB — NOT NULL
- design_cost — JSONB — NOT NULL
projects_project
- id — BIGSERIAL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- name — VARCHAR(500) — NOT NULL
- status — VARCHAR(40) — NOT NULL
tool_accounts_toolaccount
- id — BIGSERIAL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- category — VARCHAR(20) — NOT NULL
- tool — VARCHAR(20) — NOT NULL
- account_name — VARCHAR(255) — NOT NULL
- encrypted_password — TEXT — NOT NULL
- memo — TEXT — NOT NULL
- status — VARCHAR(20) — NOT NULL
- subscription_type — VARCHAR(30) — NOT NULL
- amount — NUMERIC(12,0)
- currency — VARCHAR(10) — NOT NULL