ssno
Tables (3)
course_info
- course_no — number(10) — Primary key — NOT NULL
- course_name — varchar2(50) — NOT NULL
- course_thm — varchar2(100) — NOT NULL
- course_intro — varchar2(2000) — NOT NULL
- course_start — varchar2(20) — NOT NULL
- course_end — varchar2(20) — NOT NULL
- duration_time — varchar2(20) — NOT NULL
- course_len — varchar2(20) — NOT NULL
- rating_diff — number(10) — NOT NULL
- rating_fun — number(10) — NOT NULL
- rating_cond — number(10) — NOT NULL
- pic_path — varchar2(100) — NOT NULL
- course_other1 — varchar2(100) — NOT NULL
- course_other2 — varchar2(100) — NOT NULL
- course_other3 — varchar2(100) — NOT NULL
review
- review_no — number(20) — Primary key — NOT NULL
- reservation_no — number(30) — NOT NULL
- urating_diff — number(10)
- urating_fun — number(10)
- urating_cond — number(10)
- review_comment — varchar2(1000) — archar2(1000
- review_date — date
user_info
- user_id — varchar2(20) — Primary key — NOT NULL
- user_pw — varchar2(20) — NOT NULL
- user_name — varchar2(20) — NOT NULL
- user_phone — varchar2(11) — NOT NULL
- user_license — varchar2(30) — NOT NULL