원디대

테이블 (42)

anniversary (Untitled19)

  • year (Field)
  • name (Field2)
  • date (Field3)

board (Untitled16)

  • board_code (Field)
  • borad_name (Field2)
  • use_yn (Field3)
  • board_type (Field4)
  • is_board_type (Field5)
  • is_file (Field6)
  • is_thumbnail_tage (Field7)
  • is_external (Field8)
  • is_master(삭제 가능 여부 default : N) (Field9)

board_auth (Untitled33)

  • board_id (Key) — 기본 키 — NOT NULL
  • user_id (Key2) — 기본 키 — NOT NULL
  • top_notice_auth (Field)
  • update_delete_auth (Field2)
  • write_auth (Field3)

board_content (Untitled32)

  • board_id (Key) — 기본 키 — NOT NULL
  • title (Field)
  • content (Field2)

common_code (Untitled12)

  • group_code (Field)
  • group_name (Field2)
  • text (Field3)
  • del_yn (Field4)

department (Untitled11)

  • department_code (Field)
  • department_name (Field2)
  • use_yn (Field3)
  • description (Field4)

develop_lecture_info (Untitled26)

  • year (Field13)
  • semester (Field12)
  • count (Field)
  • department (Field2)
  • grade (Field3)
  • professor_name (Field4)
  • full_time_yn (Field5)
  • public_yn (Field6)
  • experience_yn (Field7)
  • develop_type (Field8)
  • develop_change (Field9)
  • develop_year (Field10)
  • subtitle (Field11)

develop_lecture_info_memo (Untitled27)

  • writer_user_cd (Key) — 기본 키 — NOT NULL
  • content (Field)
  • created_at (Field2)

examination (Untitled29)

  • lecture_week_detail_id (Key) — 기본 키 — NOT NULL
  • examination_user_cd (Key2) — 기본 키 — NOT NULL
  • createa_at (Field)

lecture (Untitled17)

  • subject_id (Key) — 기본 키 — NOT NULL
  • develop_semester (Field)
  • open_semester (Field2)
  • develop_start_semester (Field3)
  • service (Field4)
  • develop_type (Field5)
  • lms_subject_code (Field6)
  • assignment_grade (Field7)
  • lecture_type (Field8)
  • week_num (Field9)
  • midterm_final_contents_type (Field10)
  • prototype_week (Field11)
  • part_develop_week (Field12)
  • pdf_gathering_yn (Field13)
  • not_use_develop_stage (Field14)

lecture_architect (Untitled23)

  • lecture_id (Key) — 기본 키 — NOT NULL
  • user_cd (Key2) — 기본 키 — NOT NULL

lecture_external_designer

  • lecture_id (Key) — 기본 키 — NOT NULL
  • user_cd (Key2) — 기본 키 — NOT NULL

lecture_internal_designer

  • lecture_id (Key) — 기본 키 — NOT NULL
  • user_cd (Key2) — 기본 키 — NOT NULL

lecture_planning_document_setting (CopyOfUntitled28)

  • lecture_id (Key) — 기본 키 — NOT NULL
  • contents_develop_goal (Field2)
  • professor_minutes (Field3)
  • subject_planning_document (Field4)
  • contents_planning_document (Field5)

lecture_professor

  • lecture_id (Key) — 기본 키 — NOT NULL
  • user_cd (Key2) — 기본 키 — NOT NULL

lecture_week_detail (Untitled22)

  • lecture_id (Key) — 기본 키 — NOT NULL
  • writer_user_cd (Key2) — 기본 키 — NOT NULL
  • week (Field)
  • stage (Field4)
  • content (Field2)
  • created_at (Field3)

lecture_week_detail_file (Untitled25)

  • lecture_week_detail_id (Key) — 기본 키 — NOT NULL
  • file_path (Field)
  • created_at (Field2)

leture_week_detail_comment (Untitled24)

  • lecture_week_detail_id (Key) — 기본 키 — NOT NULL
  • writer_user_cd (Key2) — 기본 키 — NOT NULL
  • content (Field)
  • created_at (Field2)
  • file_path (Field3)

menu (Untitled14)

  • menu_name (Field)
  • parent_menu (Field2)
  • use_yn (Field3)
  • description (Field4)

must_read_board (Untitled20)

  • wirter_user_cd (Key) — 기본 키 — NOT NULL
  • title (Field)
  • content (Field2)
  • use_yn (Field3)
  • created_at (Field4)
  • updated_at (Field5)
  • start_dt (Field6)
  • end_dt (Field7)

must_read_board_read (Untitled21)

  • read_user_cd (Key) — 기본 키 — NOT NULL
  • must_read_board_id (Key2) — 기본 키 — NOT NULL

notice (Untitled3)

  • writer_user_cd (Key) — 기본 키 — NOT NULL
  • title (Field)
  • conetent (Field2)
  • created_at (Field3)
  • updated_at (Field4)

notification (Untitled2)

  • title (Field)
  • content (Field2)
  • created_at (Field3)
  • noti_type (Field4)
  • noti_id (Field5)
  • created_at (Field6)

planning_document_setting (Untitled28)

  • type (Field)
  • contents_develop_goal (Field2)
  • professor_minutes (Field3)
  • subject_planning_document (Field4)
  • contents_planning_document (Field5)

semester_setting (Untitled18)

  • year (Field)
  • semester (Field2)
  • open_dt (Field3)
  • professor_ppt_day (Field5)
  • filming_day (Field4)
  • filming_ppt_day (Field6)
  • filming_reserv_day (Field7)
  • video_day (Field8)
  • storyboard_day (Field9)
  • contents_day (Field10)
  • ppt_upload_day (Field11)

special_filming (Untitled37)

  • architect_user_id (Key) — 기본 키 — NOT NULL
  • video_manage_user_id (Key2) — 기본 키 — NOT NULL
  • type (Field9)
  • year (Field)
  • semester (Field2)
  • subject_name (Field3)
  • professor (Field4)
  • request (Field5)
  • filming_date (Field6)
  • etc1 (Field7)
  • etc2 (Field8)

studio (Untitled8)

  • studio_name (Field)
  • region(코드) (Field2)
  • use_yn (Field3)
  • filming(코드) (Field4)
  • studio_type(코드) (Field5)
  • etc (Field6)

studio_manager (Untitled9)

  • studio_id (Key) — 기본 키 — NOT NULL
  • manager_user_cd (Key2) — 기본 키 — NOT NULL

studio_reservation (Untitled34)

  • studio_time_id (Key) — 기본 키 — NOT NULL
  • studio_id (Key2) — 기본 키 — NOT NULL
  • department_id (Key3) — 기본 키 — NOT NULL
  • subject_id (Key4) — 기본 키 — NOT NULL
  • professor_id (Key5) — 기본 키 — NOT NULL
  • video_manager_id (Key6) — 기본 키 — NOT NULL
  • reserv_impossible (Field)
  • week (Field2)
  • filming_type (Field3)
  • studio_type (Field4)
  • sc_sup_type (Field5)
  • etc (Field6)

studio_reservation_cancel (Untitled36)

  • cancel_type (Field)
  • cancel_content (Field2)

studio_reservation_file (Untitled35)

  • studio_reservation_id (Key) — 기본 키 — NOT NULL
  • file_path (Field)

studio_time (Untitled7)

  • date (Field8)
  • time_name (Field)
  • start_time (Field2)
  • end_time (Field3)
  • official_yn (Field4)
  • use_yn (Field5)

subject (Untitled10)

  • subject_code (Field)
  • subject_name (Field2)
  • use_yn (Field3)
  • description (Field4)

subject_planning_document_setting (Untitled31)

  • subject_id (Key) — 기본 키 — NOT NULL
  • contents_develop_goal (Field)
  • professor_minutes (Field2)
  • subject_planning_document (Field3)
  • contents_planning_document (Field4)
  • class_planning_document (Field5)

user (Untitled)

  • user_group_id (Key) — 기본 키 — NOT NULL
  • name (Field2)
  • id (Field)
  • profile_img_path (Field3)
  • email (Field4)
  • mobile (Field5)
  • 주촬영지(common_code) (Field6)
  • 회원구분 (Field7)

user_group (Untitled6)

  • group_name (Field)

user_group_join (Untitled30)

  • user_cd (Key) — 기본 키 — NOT NULL
  • user_group_id (Key2) — 기본 키 — NOT NULL

user_group_menu (Untitled13)

  • user_group_id (Key) — 기본 키 — NOT NULL
  • menu_id (Key2) — 기본 키 — NOT NULL

user_main_page (Untitled4)

  • user_cd (Key) — 기본 키 — NOT NULL
  • type (Field)
  • position (Field2)

user_menu (Untitled15)

  • menu_id (Key) — 기본 키 — NOT NULL
  • user_cd (Key2) — 기본 키 — NOT NULL

user_notification (Untitled5)

  • notification_id (Key) — 기본 키 — NOT NULL
  • recieved_user_cd (Key2) — 기본 키 — NOT NULL
  • read_yn (Field)
  • del_yn (Field2)

weekly_process (weekly_prgoress)

  • service_week
  • goal_weekd2 (goal_week)