원디대
테이블 (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)