필드쉐어

테이블 (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)