e
Tables (3)
depart (부서)
- depart_idx (부서번호) — int — Primary key — NOT NULL
- depart_name (부서명) — varchar2(30) — NOT NULL
member (회원)
- member_idx (회원번호) — int — Primary key — NOT NULL
- depart_idx (부서번호) — int — Foreign key → depart.depart_idx — NOT NULL
- member_id (아이디) — varchar2(20) — NOT NULL
- member_pw (비밀번호) — varchar2(20) — NOT NULL
- member_name (이름) — varchar2(20) — NOT NULL
- member_age (나이) — int — NOT NULL
- member_phone (전화번호) — varchar2(20)
schedule (일정)
- schedule_idx (일정 번호) — int — Primary key — NOT NULL
- schedule_subject (제목) — varchar2(30) — NOT NULL
- schedule_place (장소) — varchar2(100)
- schedule_date (날짜) — date — NOT NULL
- schedule_public (공개여부) — varchar2(15) — NOT NULL
- schedule_depart (부서) — varchar2(30) — NOT NULL
- schedule_content (설명) — varchar2(300)