kh13-2

테이블 (8)

Item

  • item_no — number — 기본 키 — NOT NULL
  • item_name — varchar2(90)
  • item_price — number
  • item_charge — number

attach

  • attach_no — number — 기본 키 — NOT NULL
  • attach_name — varchar2(255)
  • attach_type — varchar2(90)
  • attach_size — number

board

  • board_no — number — 기본 키 — NOT NULL
  • board_title — varchar2(300)
  • board_content — varchar2(4000)
  • board_writer — varchar2(20) — NOT NULL
  • board_wtime — date
  • board_etime — date
  • board_readcount — number
  • board_group — number
  • board_target — number — NOT NULL
  • board_depth — number

member

  • member_id — varchar2(20) — 기본 키 — NOT NULL
  • member_pw — varchar2(15)
  • member_nick — varchar2(30)
  • member_birth — char(10)
  • member_contact — char(11)
  • member_email — varchar2(60)
  • member_post — varchar2(6)
  • member_address1 — varchar2(300)
  • member_address2 — varchar2(300)
  • member_level — varchar2(12)
  • member_point — number
  • member_join — date
  • member_login — date

student

  • student_id — number — 기본 키 — NOT NULL
  • name — varchar2(21)
  • korean_score — number(3)
  • english_score — number(3)
  • math_score — number(3)

메뉴 (menu)

  • menu_no — number — 기본 키 — NOT NULL
  • menu_name_kor — varchar2(90)
  • menu_name_eng — varchar2(90)
  • menu_type — varchar2(60)
  • menu_price — number

사원 (emp)

  • 사원번호 (emp_no) — number — 기본 키 — NOT NULL
  • 사원이름 (emp_name) — varchar2(21)
  • 소속부서 (emp_dept) — varchar2(30)
  • 입사일 (emp_date) — char(10)
  • 월급여 (emp_sal) — number

포켓몬스터 (pocketmon)

  • 몬스터번호 (pocketmon_mp) — number — 기본 키 — NOT NULL
  • 몬스터이름 (pocketmon_name) — varchar2(30)
  • 몬스터속성 (pocketmon_type) — varchar2(9)