school_calender
Tables (11)
classes (Schedule_6)
- cs_idx (Key) — int identity(1,1) — Primary key — NOT NULL
- cs_name (수업이름) — varchar(20)
- teacher (선생) — varchar(10)
- sd_id (식별번호) — int
- cs_day (요일) — char(1)
- cs_array (교시번째) — int
copy_drive (Untitled)
- cd_idx (기록장) — int identity(1,1) — Primary key — NOT NULL
- cd_title (제목) — varchar(100)
- cd_memo (메모) — text
- cd_file_name (파일명) — varchar(100)
- cd_writer (작성자) — varchar(100)
- cd_file_path (파일경로) — varchar(100)
- cd_share_1 (공유자1) — varchar(100)
- cd_share_2 (공유자2) — varchar(100)
- cd_file_size (파일크기) — varchar(10)
- cd_level (표시레벨) — int
- cd_upload (업로드날짜) — datetime
- cd_update (업뎃날짜) — datetime
- cd_delete (삭제날짜) — datetime
dl_id (User_2)
- dl_no (기록장) — int identity(1,1) — Primary key — NOT NULL
- us_id (아이디) — varchar(25)
- dl_date (탈퇴시간) — datetime
- dl_reason (이유) — text
entire_schedule (Schedule_1)
- sd_idx (기록장) — int identity(1,1) — Primary key — NOT NULL
- sd_title (제목) — varchar(100)
- sd_s_date (시작날짜) — datetime
- sd_e_date (끝날짜) — datetime
- sd_upload_date (과제부여날짜) — datetime
- sd_required (준비물) — varchar(150)
- sd_kind (세부분류) — varchar(50)
- sd_level (업뎃여부) — int
- sd_id (식별번호) — int
mng (Manage_a)
- ex_idx (Key) — int identity(1,1) — Primary key — NOT NULL
- ex (확장자) — varchar(100)
- file_v (버젼) — int
- block_id (차단) — varchar(100)
not_ctrls_complete (User_5)
- cs_idx (기록장) — int identity(1,1) — Primary key — NOT NULL
- sd_idx (식별번호) — int
- us_id (아이디) — varchar(25)
- cs_persent (진행상태) — int
- cs_date (완료날짜) — datetime
- cs_ox (완료여부) — char(1)
- cs_level (표시여부) — int
performance_assessment (Schedule_5)
- pa_idx (기록장) — int identity(1,1) — Primary key — NOT NULL
- teacher (평가쌤) — varchar(10)
- sd_kind (세부분류) — varchar(50)
- pa_explain (내용설명) — text
- pa_criterion (평가기준) — text
- pa_group (팀인원) — int
- sd_id (식별번호) — int
- sd_idx (sc기복장) — int
schedule_complete (Schedule_2)
- sc_idx (기록장) — int identity(1,1) — Primary key — NOT NULL
- sd_id (식별번호) — int
- us_id (아이디) — varchar(25)
- sc_persent (진행상태) — int
- sc_date (완료날짜) — datetime
- sc_ox (완료여부) — char(1)
tasks (Schedule_4)
- tk_idx (기록장) — int identity(1,1) — Primary key — NOT NULL
- teacher (제출쌤) — varchar(10)
- sd_kind (세부분류) — varchar(50)
- tk_explain (내용설명) — text
- tk_group (팀인원) — int
- sd_id (식별번호) — int
- sd_idx (sc기록자) — int
- tk_e_date (제출날짜) — datetime
us_login (User_1)
- us_login_idx (Key) — int identity(1,1) — Primary key — NOT NULL
- us_id (아이디) — varchar(25)
- us_login_date (로그인시간) — datetime
- us_ip (ip확인) — varchar(20)
- us_bf_page (전페이지) — varchar(255)
- us_now_page (지금페이지) — varchar(255)
- us_device (접속기기) — int
- us_lg_kind (inout) — varchar(10)
user_info (User_3)
- user_idx (고유번호) — int identity(1,1) — Primary key — NOT NULL
- us_id (아이디) — varchar(25)
- us_pwd (비밀번호) — varchar(50)
- us_name (이름) — varchar(10)
- us_birth (생일) — datetime
- us_class (반) — int
- us_number (번호) — int
- us_level (직급) — int
- us_gender (성별) — char(1)
- us_try_date (가입시도) — datetime
- us_signup_date (가입승인) — datetime
- us_homeT (담임선생님) — varchar(20)
- first_login (첫로그인) — char(1)