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)