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)