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)