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