ExProject

Tables (3)

TB_DEVELOPER (개발자)

  • id (아이디) — NOT NULL — Foreign key → TB_USER.id
  • type (개발직군) — NOT NULL

TB_NOTICE (공지사항)

  • notice_no (공지사항 번호) — NOT NULL — Primary key
  • title (제목) — NOT NULL
  • content (내용) — NOT NULL
  • create_date (작성일자) — NOT NULL
  • writer (작성자) — NOT NULL — Foreign key → TB_USER.id
  • file (첨부파일) — NOT NULL
  • modi_date (수정일자) — NOT NULL

TB_USER (사용자)

  • id (아이디) — NOT NULL — Primary key
  • passwd (비밀번호) — NOT NULL
  • name (이름) — NOT NULL
  • nickname (별명) — NOT NULL
  • Email (이메일) — NOT NULL
  • create_date (생성일자) — NOT NULL
  • auth (권한) — NOT NULL