plang_organization_relationship

Tables (14)

Board (Untitled9)

  • board_id (Key) — string — Primary key — NOT NULL
  • name (Field) — string
  • created_at (Field2) — datetime
  • updated_at (Field3) — datetime
  • board_type (Field4) — string

BoardContent (Untitled10)

  • id (Key) — bigint — Primary key — NOT NULL
  • board_id (Key2) — string — Foreign key → Board.board_id — NOT NULL
  • reaction_count (Field) — integer
  • substance (Field2) — string
  • created_at (Field3) — datetime
  • updated_at (Field4) — datetime
  • user_status (Field5) — jsonb
  • user_id (Field6) — bigint
  • reply_count (Field7) — integer
  • helped_count (Field8) — integer
  • me_too_count (Field9) — integer
  • board_content_state (Field10) — string
  • view_count (Field11) — integer
  • report_count (Field12) — integer
  • extra_data (Field13) — jsonb
  • resolved (Field14) — boolean

ClassTask (Untitled11)

  • id (Key) — bigint — Primary key — NOT NULL
  • organization_id (Key2) — bigint — Foreign key → Organization.id — NOT NULL
  • org_manager_id (Key22) — bigint — Foreign key → OrgManager.id — NOT NULL
  • class_task_folder_id (Key3) — bigint — Foreign key → ClassTaskFolder.id — NOT NULL
  • audio_items (Field) — jsonb
  • session_count (Field2) — integer
  • task_details (Field3) — jsonb
  • title (Field4) — string
  • type (Field5) — string
  • created_at (Field6) — datetime
  • updated_at (Field7) — datetime

ClassTaskFolder (Untitled12)

  • id (Key) — bigint — Primary key — NOT NULL
  • organization_id (Key2) — bigint — Foreign key → Organization.id — NOT NULL
  • children_count (Field) — integer
  • direct_children_count (Field2) — integer
  • title (Field3) — string
  • uuid (Field4) — string
  • created_at (Field5) — datetime
  • updated_at (Field6) — datetime
  • parent_folder_id (Field7) — bigint

ClassTaskSession (Untitled13)

  • id (Key) — bigint — Primary key — NOT NULL
  • class_tasl_id (Key2) — bigint — Foreign key → ClassTask.id — NOT NULL
  • org_manager_id (Key22) — bigint — Foreign key → OrgManager.id — NOT NULL
  • org_group_id (Key23) — bigint — Foreign key → OrgGroup.id — NOT NULL
  • task_summary (Field) — jsonb
  • expires_at (Field2) — datetime
  • created_at (Field3) — datetime
  • updated_at (Field4) — datetime
  • type (Field5) — string
  • message_data (Field6) — jsonb

ClassTaskSubmission (Untitled14)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (Key3) — bigint — Foreign key → User.id — NOT NULL
  • class_task_session_id (Key2) — bigint — Foreign key → ClassTaskSession.id — NOT NULL
  • answer (Field) — text
  • step (Field2) — integer
  • finished_at (Field3) — datetime
  • analysis (Field4) — jsonb
  • feedback (Field5) — text
  • revoked_at (Field6) — datetime
  • created_at (Field7) — datetime
  • updated_at (Field8) — datetime
  • answered_at (Field9) — datetime
  • analyzed_at (Field10) — datetime
  • manager_feedback (Field11) — text
  • submission_details (Field12) — jsonb
  • type (Field13) — string

CompanyUserInfo (Untitled7)

  • id (Key) — bigint — Primary key — NOT NULL
  • org_seat_purchase_id (Key3) — bigint — Foreign key → OrgSeatPurchase.id — NOT NULL
  • account_Created_at (Field) — datetime
  • email (Field2) — string
  • email_sent_at (Field3) — datetime
  • encrypted_password (Field4) — string
  • end_time (Field5) — datetime
  • extra_info (Field6) — jsonb
  • name (Field7) — string
  • password_legacy (Field8) — string
  • start_time (Field9) — datetime
  • type (Field10) — string
  • user_name (Field11) — string
  • created_at (Field12) — datetime
  • updated_at (Field13) — datetime
  • org_group_id (Field14) — bigint
  • organization_id (Field15) — bigint

OrgGroup (Untitled2)

  • id (Key2) — bigint — Primary key — NOT NULL
  • organization_id (Key) — bigint — Foreign key → Organization.id — NOT NULL
  • org_group_set_id (Key3) — bigint — Foreign key → OrgGroupSet.id — NOT NULL
  • class _task_session_count (Field) — int
  • end_date (Field2) — datetime
  • name (Field3) — str
  • start_date (Field4) — datetime
  • user_count (Field5) — int
  • created_at (Field6) — datetime
  • updated_at (Field7) — datetime

OrgGroupSet (Untitled6)

  • id (Key) — bigint — Primary key — NOT NULL
  • organization_id (Key2) — bigint — Foreign key → Organization.id — NOT NULL
  • name (Field) — string
  • org_groups_count (Field2) — integer
  • created_at (Field3) — datetime
  • updated_at (Field4) — datetime
  • creation_flag_id (Field5) — string

OrgGroupUser (Untitled3)

  • id (Key) — bigint — Primary key — NOT NULL
  • org_group_id (Key2) — bigint — Foreign key → OrgGroup.id — NOT NULL
  • user_id (Key3) — bigint — Foreign key → User.id — NOT NULL
  • created_at (Field) — datetime
  • updated_at (Field2) — datetime

OrgManager (Untitled5)

  • id (Key2) — bigint — Primary key — NOT NULL
  • organization_id (Key) — bigint — Foreign key → Organization.id — NOT NULL
  • email (Field) — string
  • encrypted_password (Field2) — string
  • reset_password_token (Field3) — string
  • reset_password_sent_at (Field4) — datetime
  • remember_create_at (Field5) — datetime
  • sign_in_count (Field6) — integer
  • current_sign_in_at (Field7) — datetime
  • last_sign_in_at (Field8) — datetime
  • current_sign_in_ip (Field9) — string
  • last_sign_in_ip (Field10) — string
  • created_at (Field11) — datetime
  • updated_at (Field12) — datetime
  • user_id (Field13) — bigint

OrgSeatPurchase (Untitled8)

  • id (Key) — bigint — Primary key — NOT NULL
  • organization_id (Key2) — bigint — Foreign key → Organization.id — NOT NULL
  • end_date (Field) — date
  • seats (Field2) — integer
  • start_date (Field3) — date
  • used_seats (Field4) — integer
  • created_at (Field5) — datetime
  • updated_at (Field6) — datetime

Organization (Untitled)

  • id (Key) — bigint — Primary key — NOT NULL
  • qna_board_id (Key2) — string — Foreign key → Board.board_id — NOT NULL
  • goal_share_board_id (Key3) — string — Foreign key → Board.board_id — NOT NULL
  • idea_board_id (Key4) — string — Foreign key → Board.board_id — NOT NULL
  • options (Field) — string
  • watch_mode (Field2) — boolean
  • created_at (Field3) — datetime
  • updated_at (Field4) — datetime
  • unique_id (Field5) — string

User (Untitled4)

  • id (Key) — bigint — Primary key — NOT NULL