ddd

Tables (21)

Untitled2

  • room_id (Field)
  • teacher_id (Field2)
  • student_id (Field3)

tbl_admin_info

  • admin_id — varchar(32) — NOT NULL
  • password — varchar(64) — NOT NULL
  • note — text — NOT NULL
  • create_date — timestamp — NOT NULL
  • update_date — timestamp — NOT NULL
  • admin_name — varchar(32) — NOT NULL

tbl_admin_ip

  • admin_ip — varchar(32) — Primary key — NOT NULL
  • note — text

tbl_capture (CopyOftbl_teaxcher2)

  • room_id (Key2) — Foreign key → tbl_class.room_id — NOT NULL
  • saved_name (Field)
  • dir (Field2)
  • create_date (Field3)

tbl_charging

  • cp_code — varchar(32) — Primary key — NOT NULL
  • start_date — timestamp — Primary key — NOT NULL
  • user_id — varchar(32) — Primary key — NOT NULL
  • room_id — varchar(32) — Primary key — NOT NULL
  • create_date — timestamp — NOT NULL
  • user_name — varchar(32) — NOT NULL
  • client_ip — varchar(32) — NOT NULL
  • room_idx — int4 — NOT NULL
  • end_date — timestamp — NOT NULL
  • usage_time — varchar(16) — NOT NULL
  • usage_type — varchar(8) — NOT NULL

tbl_class (Untitled)

  • id (Key) — Primary key — NOT NULL
  • room_id (Key2) — Foreign key → tbl_room_id.id — NOT NULL
  • create_date (Field)
  • status (Field2)

tbl_client_log

  • create_date — timestamp — Primary key — NOT NULL
  • idx — serial
  • type — integer
  • user_id — text
  • room_id — text
  • content — text

tbl_license

  • cp_code — varchar(32) — NOT NULL — 사용자가
  • auth_code — text — NOT NULL — API
  • allow_max_user — integer
  • allow_start_date — timestamp
  • allow_end_date — timestamp
  • create_date — timestamp — NOT NULL
  • update_date — timestamp — NOT NULL
  • category — varchar(32) — 서비스
  • cp_name — varchar(32) — NOT NULL
  • decoding_key — varchar(64) — 인증
  • cp_phone_number — varchar(16)
  • name — varchar(8)
  • phone_number — varchar(16)
  • email — varchar(64)
  • is_deleted — boolean — NOT NULL
  • note — text — 예)

tbl_log_class_result

  • idx — serial
  • room_id — text
  • class_status — text
  • create_date — timestamp — NOT NULL

tbl_log_type

  • idx — integer — Primary key — NOT NULL
  • description — text

tbl_meta (CopyOfCopyOfCopyOftbl_teaxcher2)

  • room_id (Key2) — Foreign key → tbl_class.room_id — NOT NULL
  • textbook_title (Field)
  • end_date (Field4)
  • is_error (Field2)

tbl_record (CopyOfCopyOftbl_teaxcher2)

  • room_id (Key2) — Foreign key → tbl_class.room_id — NOT NULL
  • saved_name (Field)
  • size (Field2)
  • create_date (Field3)
  • end_date (Field4)

tbl_report_error

  • idx — serial
  • type — text — NOT NULL — talksam,
  • room_id — text — room
  • user_id — text — user
  • error_name — text — error
  • message — text — error
  • stack — text — stack
  • code — text — error
  • send_date — timestamp — NOT NULL — send
  • create_date — timestamp — NOT NULL — create

tbl_room_id

  • id (Key) — Primary key — NOT NULL
  • idx — integer — NOT NULL
  • room_id — varchar(32) — NOT NULL
  • cp_code — varchar(32) — NOT NULL
  • create_date — timestamp — NOT NULL

tbl_student (CopyOftbl_teaxcher)

  • room_id (Key22) — Foreign key → tbl_class.room_id — NOT NULL
  • teacher_id (Key222) — Foreign key → tbl_teacher.room_id — NOT NULL
  • id (Field)
  • name (Field2)
  • age (Field3)
  • entrance_time (Field4)

tbl_teacher (tbl_teaxcher)

  • room_id (Key22) — Foreign key → tbl_class.room_id — NOT NULL
  • id (Field)
  • name (Field2)

tbl_textbook

  • idx — serial
  • type — text — NOT NULL — talksam,
  • teacher_id — text — NOT NULL — 선생님
  • original_name — text — NOT NULL — 원본
  • saved_name — text — NOT NULL — 저장된
  • display_name — text — NOT NULL — 원본
  • extension — text — NOT NULL — 확장자
  • dir — text — NOT NULL — 저장된
  • image_count — integer — 이미지

tbl_transaction

  • idx — integer — NOT NULL
  • cp_code — varchar(32) — NOT NULL
  • user_id — varchar(32)
  • user_name — varchar(32)
  • op_code — varchar(32) — NOT NULL — API
  • create_date — timestamp — NOT NULL
  • user_count — integer
  • room_id — varchar(32)
  • client_ip — varchar(32) — NOT NULL
  • result_code — varchar(8) — NOT NULL

tbl_usage_count_statistics

  • statistics_time — varchar(32) — NOT NULL
  • create_date — timestamp — NOT NULL
  • cp_code — varchar(32) — NOT NULL
  • success_count — integer — NOT NULL

tbl_usage_time_statistics

  • statistics_time — varchar(32)
  • create_date — timestamp — NOT NULL
  • cp_code — varchar(32) — NOT NULL
  • p2p_total_time — varchar(16) — 예)00:00:00
  • n2n_total_time — varchar(16) — 예)00:00:00

tbl_video_image

  • idx — serial
  • type — text — NOT NULL — talksam,
  • original_name — text — NOT NULL — 원본
  • saved_name — text — NOT NULL — 저장된
  • extension — text — NOT NULL — 확장자
  • dir — text — NOT NULL — 저장된
  • size — integer — NOT NULL — 용량
  • create_date — timestamp — NOT NULL