Dog
Tables (21)
Article
- Key (ar_no) — number — Primary key — NOT NULL
- Key (ar_userNo) — number — Foreign key → Member.Key — NOT NULL
- Key (ar_tourNo) — number — Foreign key → Tour.Key — NOT NULL
- Field (ar_title) — varchar2(100)
- Field2 (ar_content) — CLOB
- Field3 (ar_userId) — varchar2(50)
- Field (ar_createdDate) — Date
- Field (ar_like) — number
- Field (ar_view) — number
CartItem
- Key (ci_no) — number — Primary key — NOT NULL
- Key (pd_no) — number — Foreign key → Product.Key — NOT NULL
- Key (m_no) — number — Foreign key → Member.Key — NOT NULL
- Field (ci_quantity) — number
ChatMessage
- Key — Primary key — NOT NULL
ChatRoom
- Key — Primary key — NOT NULL
Comment
- (c_no) — number — Primary key — NOT NULL
- Key (ar_no) — number — Foreign key → Article.Key — NOT NULL
- Key (m_no) — number — Foreign key → Member.Key — NOT NULL
- Key (n_no) — number — Foreign key → Notice.Key — NOT NULL
- Field (c_category) — number
- Field3 (c_parentNo) — number
- Field4 (c_userId) — varchar2(50)
- Field (c_dept) — number
- Field (c_content) — varchar2(1000)
- Field (c_createdDate) — Date
- Field (c_like) — number
Dog
- Key (d_no) — number — Primary key — NOT NULL
- Key (m_no) — number — Foreign key → Member.Key — NOT NULL
- Field3 (d_name) — varchar2(40)
- Field4 (d_breed) — varchar2(40)
- Field5 (d_size) — number
Hotel
- Key (h_no) — number — Primary key — NOT NULL
- Key (t_no) — number — Foreign key → Tour.Key — NOT NULL
- Field (h_name) — varchar2(200)
- Field (h_price) — number
- Field (h_location) — varchar2(200)
Img
- Key (i_no) — number — Primary key — NOT NULL
- Key (pd_no) — number — Foreign key → Product.Key — NOT NULL
- Key (t_no) — number — Foreign key → Tour.Key — NOT NULL
- Key (ar_no) — number — Foreign key → Article.Key — NOT NULL
- Field (i_category) — varchar2(20)
- Field (i_order) — number
Member
- Key (m_no) — number — Primary key — NOT NULL
- Key (pf_no) — number — Foreign key → Preference.Key — NOT NULL
- Field (m_userId) — varchar2(50)
- Field2 (m_name) — varchar2(40)
- Field3 (m_email) — varchar2(100)
- Field4 (m_password) — varchar2(200)
- Field (m_phone) — number
- Field (m_basicAddress) — varchar2(100)
- Field (m_detailAddress) — varchar2(100)
- Field (m_postNo) — varchar2(50)
Notice
- Key (n_no) — number — Primary key — NOT NULL
- Field (n_title) — varchar2(100)
- Field (n_content) — CLOB
- Field (n_createdDate) — Date
- Field (n_view) — number
OrderItem
- Key (oi_no) — number — Primary key — NOT NULL
- Key (pd_no) — number — Foreign key → Product.Key — NOT NULL
- Key (m_no) — number — Foreign key → Member.Key — NOT NULL
- Field3 (oi_quantity) — number
- Field (oi_orderDate) — Date
- Field (oi_basicAddress) — varchar2(100)
- Field (oi_detailAddress) — varchar2(100)
- Field (oi_postNo) — varchar2(50)
- Field (oi_status) — number
OrderTour
- Key (ot_no) — number — Primary key — NOT NULL
- Key (m_no) — number — Foreign key → Member.Key — NOT NULL
- Field (t_no) — number
- Field3 (ot_orderDate) — Date
- Field4 (ot_status) — number
PaymentItem
- Key (pay_no) — number — Primary key — NOT NULL
- Key (oi_no) — number — Foreign key → OrderItem.Key — NOT NULL
- Field2 (pay_type) — number
- Field4 (pay_Date) — Date
PaymentTour
- Key (pay_no) — number — Primary key — NOT NULL
- Key (ot_no) — number — Foreign key → OrderTour.Key — NOT NULL
- Field2 (pay_type) — number
- Field4 (pay_Date) — Date
Place
- Key (pl_no) — number — Primary key — NOT NULL
- Key (tourNo) — number — Foreign key → Tour.Key — NOT NULL
- Field (pl_location) — varchar2(300)
- Field (pl_name) — varchar2(200)
Preference
- Key (pf_no) — number — Primary key — NOT NULL
- Field (pf_rest) — number
- Field2 (pf_sport) — number
- Field3 (pf_walk) — number
- Field4 (pf_cafe) — number
- Field (pf_spot) — number
Product
- Key (pd_no) — number — Primary key — NOT NULL
- Field (pd_name) — varchar2(100)
- Field2 (pd_explain) — varchar2(200)
- Field4 (pd_mount) — number
- Field (pd_price) — number
- Field (pd_discount) — number
- Field (pd_registrationDate) — Date
- Field (pd_category) — number
Restaurante
- Key (res_no) — number — Primary key — NOT NULL
- Key (t_no) — number — Foreign key → Tour.Key — NOT NULL
- Field (res_location) — varchar2(300)
- Field (res_name) — varchar2(200)
Tour
- Key (t_no) — number — Primary key — NOT NULL
- Key (pf_no) — number — Foreign key → Preference.Key — NOT NULL
- Field (t_title) — varchar2(100)
- Field (t_explain) — CLOB
- Field (t_totalPrice) — number
- Field (t_strDate) — Date
- Field (t_endDate) — Date
TourImg
- Key (ti_no) — number — Primary key — NOT NULL
- Key (t_no) — number — Foreign key → Tour.Key — NOT NULL
- Field (ti_category) — varchar2(20)
- Field (ti_order) — number
- Field (ti_day) — number
UserTourList
- Key (tl_no) — number — Primary key — NOT NULL
- Key (m_no) — number — Foreign key → Member.Key — NOT NULL
- Key (t_no) — number — Foreign key → Tour.Key — NOT NULL
- Field (utl_status) — number