필드쉐어
테이블 (12)
Bill (CopyOfUntitled13)
- Key (_id) — 기본 키 — NOT NULL
- created_at
- expired
- expired_code
- > id (Field6)
- > expired (Field4)
- > use_date (Field5)
- status_change
- ticket_id
- lesson_id
- type
- Field3
- fac_id (Key) — 외래 키 → Facility._id — NOT NULL
- user_id (Key2) — 외래 키 → User._id — NOT NULL
- partners_id (Key3) — String[] — 외래 키 → Partners.Key — NOT NULL
Facility (Untitled4)
- _id (Key) — 기본 키 — NOT NULL
- active (Field)
- address (Field2)
- address_detail (Field3)
- follows (Field4)
- hours (Field5)
- > monday (Field6) — 시간json
- > tuesday (Field7) — 시간json
- > wednesday (Field8) — 시간json
- > thursday (Field9) — 시간json
- > friday (Field10) — 시간json
- > saturday (Field11) — 시간json
- > sunday (Field12) — 시간json
- img_urls (Field13)
- latitude (Field14)
- longitude (Field16)
- main_img_url (Field17)
- notice (Field18)
- options (Field19)
- phone_number (Field20)
- rating (Field21)
- reserve_prereq (Field22)
- reviews (Field23)
- sport (Field24)
- title (Field25)
- type (Field26)
- web_url (Field27)
- youtube_id (Field28)
- fav (Field29)
- partner_id (Key2) — 외래 키 → Partners.Key — NOT NULL
Partners (Untitled17)
- Key — 기본 키 — NOT NULL
- business_registraiton_number (Field)
- contact_name (Field2)
- contact_phone (Field3)
- created_at (Field4)
- email (Field5)
- short_title (Field6)
- contract (Field7)
- > lesson_p_charge (Field12)
- > lesson_u_charge (Field13)
- > ticket_p_charge (Field14)
- > res_p_charge (Field15)
- > res_u_charge (Field16)
- > payback_day (Field17)
- membership (Field8)
- > expiration_date (Field18)
- > start_date (Field11)
- > status (Field19)
- > type (Field20)
- fac_id (Key2) — 외래 키 → Facility._id — NOT NULL
Promotion (Untitled8)
- Key — 기본 키 — NOT NULL
- banner_inner_url (Field)
- banner_main_url (Field2)
- desc (Field3)
- order (Field6)
- tag (Field7)
- title (Field9)
- type (Field10)
- visible (Field11)
- facilities (Key2) — 외래 키 → Facility._id — NOT NULL
- lesson (Key3) — 외래 키 → lesson.Key — NOT NULL
- ticket (Key4) — 외래 키 → Ticket.Key — NOT NULL
Recent (Untitled11)
- Key — 기본 키 — NOT NULL
- fac (Field)
- lesson (Field2)
- > id (Field5)
- > search_at (Field6)
- ticket (Field3)
- > id (Field7)
- > search_at (Field8)
- user_id (Key2) — 외래 키 → User._id — NOT NULL
Reservation (Untitled5)
- _id (Key) — 기본 키 — NOT NULL
- created_at (Field)
- start_date (Field2)
- end_date (Field3)
- partners_id (Field4)
- user_id (Field5)
- status_change (Field6)
- > satus (Field18)
- > updated_at (Field16)
- > msg (Field17)
- trans_id (Field7)
- fac_id (Field8)
- > name (Field9)
- > phone (Field10)
- > memo (Field11)
- fac_id (Field12)
- method (Field13)
- same_time (Field15)
- type (Field14)
Review (Untitled14)
- _id (Key) — 기본 키 — NOT NULL
- content (Field)
- created_at (Field2)
- img_urls_list (Field4)
- rating (Field5)
- comment (Field7)
- > user_id (Field8)
- > created_at (Field9)
- > content (Field10)
- type (Field11)
- reply (Field12)
- > reated_at (Field13)
- > content (Field14)
- fac_id (Key2) — 외래 키 → Facility._id — NOT NULL
- user_id (Key3) — 외래 키 → User._id — NOT NULL
Ticket (Untitled12)
- Key — 기본 키 — NOT NULL
- dc_price (Field)
- detail_info (Field2)
- on_sale (Field3)
- on_day (Field4)
- sales_start (Field6)
- sales_end (Field5)
- title (Field7)
- total (Field8)
- img_url (Field9)
- remain (Field12)
- Field10 — String[]
- Field11
Trans : 결제 (Untitled3)
- Key — 기본 키 — NOT NULL
- kind (Field)
- partners_id (Field2)
- pay_at (Field3)
- price (Field4)
- o_price (Field5)
- type (Field6)
- status (Field9)
- refund (Field10)
- payback (Field16)
- > amount (Field20)
- > payback_date (Field19)
- u_charge (Field18)
- p_charge (Field17)
- fac_id (Key2) — 외래 키 → Facility._id — NOT NULL
- user_id (Key3) — 외래 키 → User._id — NOT NULL
- bill_id (_id) — 외래 키 → Bill.Key — NOT NULL
- lesson_id (Key4) — 외래 키 → lesson.Key — NOT NULL
- ticket_id (Key5) — 외래 키 → Ticket.Key — NOT NULL
- res_id (Key6) — 외래 키 → Reservation._id — NOT NULL
- partners_id (Key7) — String[] — 외래 키 → Partners.Key — NOT NULL
User (Untitled6)
- _id (Key) — 기본 키 — NOT NULL
- created_at (Field)
- agreed_terms (Field2)
- email (Field3)
- followings (Field4)
- gender (Field5)
- phone (Field6)
- profile_pic_url (Field7)
- username (Field8)
- fav_sports (Field9)
- updated_at (Field10)
lesson (Untitled2)
- Key — 기본 키 — NOT NULL
- type (img_urls)
- name
- carrer
- award
- title
- sales_start
- sales_end
- lesson_start
- lesson_end
- price
- count
- bold (Field3)
- tc_info (Field4)
- lesson_info (Field5)
- prepare (Field6)
- on_sale (Field7)
- amount (Field10)
- day (Field11)
- Field
- Field2
시간json (Untitled)
- 24hr (Field) — boolean
- close_time (Field2)
- open_tiem (Field3)
- time (Field4)
- pricing (Field5)
- > count (Field6)
- > end_time (Field7)
- > per (Field8)
- > price (Field9)
- > start_time (Field10)
- > tag (Field11)