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