asset mk2

Tables (6)

Asset_relation (자산)

  • Asset_id (notion) — pk — Primary key — NOT NULL
  • Asset_name (VARCHAR[25])
  • Asset_type (Field2)
  • Asset_check (Field3)
  • Time_Relation_id (notion2) — nk — Foreign key → Time_relation.Time_Relation_id — NOT NULL

Financial_Asset (Untitled)

  • Asset_id (notion) — pk,nk — Primary key — NOT NULL
  • financial_type (Field)
  • account_number (Field2)
  • current_value (Field3)

Human&Social_asset (CopyOfUntitled2)

  • Asset_id (notion) — pk,nk — Primary key — NOT NULL
  • Model_name (VARCHAR[25])
  • Status (VARCHAR[50])
  • Purchase_date (date)
  • Tangible_Asset_id (.) — NOT NULL

Tangible_Asset (Untitled2)

  • Asset_id (notion) — pk,nk — Primary key — NOT NULL
  • Model_name (VARCHAR[25])
  • Status (VARCHAR[50])
  • Purchase_date (date)
  • Tangible_Asset_id (.) — NOT NULL

Time_relation (Untitled4)

  • Time_Relation_id (notion) — pk,nk — Primary key — NOT NULL
  • Time_Start (date time)
  • Category (VARCHAR[100])
  • Time_End (data time)
  • Data_detail (JSON)

intangible_asset (Untitled3)

  • Asset_id (notion) — pk — Primary key — NOT NULL
  • Field