activity set 속성

테이블 (3)

activity_set_tag

  • id — char(36) — 기본 키 — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • deleted_at — datetime(6)
  • creator_id — bigint — NOT NULL
  • name — VARCHAR(255)

activity_set_unit

  • id — char(36) — 기본 키 — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • deleted_at — datetime(6)
  • title — VARCHAR(255)
  • description — VARCHAR(255) — NOT NULL
  • view_datas — json — NOT NULL
  • creator_id — bigint — NOT NULL
  • view_type — VARCHAR(255)
  • is_estimative — tinyint — NOT NULL
  • difficulty — tinyint
  • evaluation_period — tinyint

activity_set_unit_activity_set_tag

  • id — char(36) — 기본 키 — NOT NULL
  • activity_set_unit_id (id2) — char(36) — 외래 키 → activity_set_unit.id — NOT NULL
  • activity_set_tag_id (id3) — char(36) — 외래 키 → activity_set_tag.id — NOT NULL
  • creator_id — bigint — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • deleted_at — datetime(6)