더 숲

테이블 (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