-- phpMyAdmin SQL Dump
-- version 4.9.4
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- 생성 시간: 20-02-23 13:53
-- 서버 버전: 10.1.13-MariaDB
-- PHP 버전: 7.3.1p1

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- 데이터베이스: `superstream`
--

-- --------------------------------------------------------

--
-- 테이블 구조 `tb_eval_homework`
--

CREATE TABLE `tb_eval_homework` (
  `homework_id` int(10) UNSIGNED NOT NULL,
  `homework_name` varchar(512) NOT NULL COMMENT '과제명',
  `home_sdatetime` datetime NOT NULL COMMENT '제출시작',
  `home_edatetime` datetime NOT NULL COMMENT '제출종료',
  `home_add_submission` tinyint(4) NOT NULL COMMENT '추가제출사용',
  `home_add_deduction` tinyint(4) NOT NULL COMMENT '추가제출감점율',
  `home_add_sdatetime` datetime NOT NULL COMMENT '추가제출시작',
  `home_add_edatetime` datetime NOT NULL COMMENT '추가제출종료',
  `home_public_datetime` datetime NOT NULL COMMENT '점수공개',
  `home_appeal_use` tinyint(4) NOT NULL COMMENT '이의신청사용',
  `home_appeal_sdatetime` datetime NOT NULL COMMENT '이의신청시작',
  `home_appeal_edatetime` datetime NOT NULL COMMENT '이의신청종료',
  `home_contents` text NOT NULL COMMENT '과제내용',
  `home_contents_file` varchar(255) NOT NULL COMMENT '과제내용파일',
  `home_caution` text NOT NULL COMMENT '주의사항',
  `home_caution_file` varchar(255) NOT NULL COMMENT '주의사항파일',
  `home_tips` text NOT NULL COMMENT '제출요령',
  `home_tips_file` varchar(255) NOT NULL COMMENT '제출요령파일',
  `reg_id` varchar(50) NOT NULL,
  `reg_datetime` datetime NOT NULL,
  `reg_ip` varchar(17) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='과제테이블';

--
-- 덤프된 테이블의 인덱스
--

--
-- 테이블의 인덱스 `tb_eval_homework`
--
ALTER TABLE `tb_eval_homework`
  ADD PRIMARY KEY (`homework_id`);

--
-- 덤프된 테이블의 AUTO_INCREMENT
--

--
-- 테이블의 AUTO_INCREMENT `tb_eval_homework`
--
ALTER TABLE `tb_eval_homework`
  MODIFY `homework_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
