visang

Tables (5)

company (컴퍼니명)

  • company_id (컴퍼니명) — enum — Primary key — NOT NULL

service (서비스명)

  • service_id (서비스명) — enum — Primary key — NOT NULL

service_db (서비스 db 종류)

  • service_db_id (서비스 db 종류) — enum — Primary key — NOT NULL

service_table (datahub 서비스 테이블명)

  • service_table_id (서비스테이블명) — enum — Primary key — NOT NULL

table_info (테이블 정보)

  • table_id (테이블 id) — int — Primary key — NOT NULL
  • company_id (컴퍼니명) — enum — Foreign key → company.company_id — NOT NULL
  • service_id (서비스명) — enum — Foreign key → service.service_id — NOT NULL
  • service_table_id (서비스테이블명) — enum — Foreign key → service_table.service_table_id — NOT NULL
  • service_db_id (서비스 db 종류) — enum — Foreign key → service_db.service_db_id — NOT NULL
  • table_name (테이블명) — string
  • table_description (테이블 설명) — text