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)