team project

Tables (7)

Booking_3 (booking_3)

  • tablenum — number(7) — Primary key — NOT NULL
  • id — varchar2(20) — Foreign key → Member_3.id — NOT NULL
  • storecode — number(7) — Foreign key → Store_3.storecode — NOT NULL
  • saramsu — number(3)
  • state — varchar2(10)
  • bookingdate — date
  • bookingtime — date

FAQ_3

  • num — number(6) — Primary key
  • id — varchar2(20) — Foreign key → Member_3.id — NOT NULL
  • title — varchar2(50)
  • content — varchar2(1000)
  • wdate — date
  • state — varchar2(20)
  • groups — number(6)
  • step — number(1)
  • secret — number(1)

Member_3 (member_3)

  • id — varchar2(20) — Primary key — NOT NULL
  • pw — varchar2(200)
  • name — varchar2(20)
  • phone — varchar2(20)
  • birth — date

Member_likes (member_likes)

  • member_id — varchar2(20) — Foreign key → Member_3.id — NOT NULL
  • storecode — number(7) — Foreign key → Store_3.storecode — NOT NULL
  • liked_at — timestamp(6)

Review_3 (review_3)

  • id — varchar2(20) — Foreign key → Member_3.id — NOT NULL
  • storecode — number(7) — Foreign key → Store_3.storecode — NOT NULL
  • content — varchar2(200)
  • stars — number(2)
  • title — varchar(50)

Store_3 (store_3)

  • storecode — number(7) — Primary key — NOT NULL
  • storename — varchar2(30)
  • storeaddress — varchar2(100)
  • storecategory — varchar2(20)
  • storelikes — number(6)
  • storearea — varchar2(20)
  • storeimage — varchar2(200)
  • parking — number(1)
  • latitude — number(20,10)
  • longitude — number(20,10)
  • storehours — varchar2(100)

Store_image_3 (store_image_3)

  • storecode — number(7) — Foreign key → Store_3.storecode — NOT NULL
  • image_filename — varchar2(200)