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