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