b7

Tables (15)

Untitled

    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