b7
Tables (15)
b7_Cart
- cart_no — NUMBER — Primary key — NOT NULL
- member_no — NUMBER — Foreign key → b7_Member.member_no — NOT NULL
- course_no — NUMBER — Foreign key → b7_CourseInfo.course_no — NOT NULL
b7_Category_List
- category_no — NUMBER — Primary key — NOT NULL
- category_name — VARCHAR2(10)
b7_Chat
- chat_no — NUMBER — Primary key — NOT NULL
- room_no — NUMBER — Foreign key → b7_ChatRoom.room_no — NOT NULL
- member_no — NUMBER — Foreign key → b7_ChatRoom.member_no — NOT NULL
- chat_text — VARCHAR2(100)
b7_ChatRoom
- room_no — NUMBER — Primary key — NOT NULL
- member_no — NUMBER — Foreign key → b7_Member.member_no — NOT NULL
b7_CourseImage
- courseImage_no — NUMBER — Primary key — NOT NULL
- course_no — NUMBER — Foreign key → b7_CourseInfo.course_no — NOT NULL
- courseImage_url — VARCHAR2(1000)
- courseImage_originalName — VARCHAR2(1000)
b7_CourseInfo
- course_no — NUMBER — Primary key — NOT NULL
- teacher_no — NUMBER — Foreign key → b7_Teacher.teacher_no — NOT NULL
- course_title — VARCHAR2(100)
- course_date — DATE
- course_price — NUMBER
- course_content — VARCHAR2(10000)
- course_count — NUMBER
b7_Course_Category
- courseCategory_no — NUMBER — Primary key — NOT NULL
- category_no — NUMBER — Foreign key → b7_Category_List.category_no — NOT NULL
- course_no — NUMBER — Foreign key → b7_CourseInfo.course_no — NOT NULL
b7_MailAuth
- mailAuth_no — NUMBER — Primary key — NOT NULL
- member_no — NUMBER — Foreign key → b7_Member.member_no — NOT NULL
- mailAuth_key — NUMBER
- mailAuth_state — VARCHAR2(1)
- mailAuth_date — DATE
b7_Member
- member_no — NUMBER — Primary key — NOT NULL
- member_id — VARCHAR2(100)
- member_pw — VARCHAR2(1000)
- member_nick — VARCHAR2(100)
- member_email — VARCHAR2(1000)
- member_birth — DATE
- member_joinDate — DATE
- member_phone — VARCHAR2(100)
b7_Order
- order_no — NUMBER — Primary key — NOT NULL
- member_no — NUMBER — Foreign key → b7_Member.member_no — NOT NULL
- course_no — NUMBER — Foreign key → b7_CourseInfo.course_no — NOT NULL
- Field (order_method) — NUMBER
- order_date — DATE
- order_refund — VARCHAR2(1)
b7_RefundInfo
- refund_no — NUMBER — Primary key — NOT NULL
- order_no — NUMBER — Foreign key → b7_Order.order_no — NOT NULL
- member_no — NUMBER — Foreign key → b7_Order.member_no — NOT NULL
- course_no — NUMBER — Foreign key → b7_Order.course_no — NOT NULL
- refund_date — DATE
b7_Reply
- reply_no — NUMBER — Primary key — NOT NULL
- order_no — NUMBER — Foreign key → b7_Order.order_no — NOT NULL
- member_no — NUMBER — Foreign key → b7_Order.member_no — NOT NULL
- course_no — NUMBER — Foreign key → b7_Order.course_no — NOT NULL
- reply_star — NUMBER
- reply_text — VARCHAR2(100)
- reply_date — DATE
b7_Teacher
- teacher_no — NUMBER — Primary key — NOT NULL
- member_no — NUMBER — Foreign key → b7_Member.member_no — NOT NULL
- Field (teacher_nick) — VARCHAR2(300)
- 소속 — VARCHAR(255)
- 분야 — VARCHAR(255)
b7_Wishlist
- wishlist_no — NUMBER — Primary key — NOT NULL
- member_no — NUMBER — Foreign key → b7_Member.member_no — NOT NULL
- course_no — NUMBER — Foreign key → b7_CourseInfo.course_no — NOT NULL