SmileRoutine

Tables (19)

Booking_log

  • Log_num (PK) — INTEGER — Primary key — NOT NULL
  • Booking_num — INTEGER — Foreign key → PR_Booking.Booking_num — NOT NULL

Chat_log

  • Log_num — INTEGER — Primary key — NOT NULL
  • Room_num — INTEGER — Foreign key → Chat_room.Room_num — NOT NULL
  • log_text — VARCHAR(255)
  • log_chatting_time — DateTime

Chat_room

  • Room_num — INTEGER — Primary key — NOT NULL
  • Host_Info_num — INTEGER — Foreign key → Host_Info.Host_Info_num — NOT NULL
  • User_num — INTEGER — Foreign key → User.User_num — NOT NULL — AUTO_INCREMENT
  • Room_making_date (Field) — VARCHAR(255)

Community

  • C_num — INTEGER — Primary key — NOT NULL
  • User_num — INTEGER — Foreign key → User.User_num — NOT NULL — AUTO_INCREMENT
  • C_title — VARCHAR(255)
  • C_text — VARCHAR(255)
  • C_category — VARCHAR(255)
  • C_making_time — DateTime

Community_jpg

  • C_jpg_num — INTEGER — Primary key — NOT NULL
  • C_num — INTEGER — Foreign key → Community.C_num — NOT NULL
  • C_jpg_origin_name — VARCHAR(255) — 파일이 업로드될 때 본명
  • C_jpg_path — VARCHAR(255)
  • C_jpg_name — VARCHAR(255) — 파일이 다운로드될 때 변경될 명

Community_reply

  • C_reply_num — INTEGER — Primary key — NOT NULL
  • C_num — INTEGER — Foreign key → Community.C_num — NOT NULL
  • User_num — INTEGER — Foreign key → User.User_num — NOT NULL — AUTO_INCREMENT
  • C_replyText — VARCHAR(255)
  • C_replyDate — DateTime
  • top_reply_num — INTEGER — Foreign key → Community_reply.C_reply_num — NOT NULL

Host_Info

  • Host_Info_num — INTEGER — Primary key — NOT NULL
  • User_num — INTEGER — Foreign key → User.User_num — NOT NULL — AUTO_INCREMENT
  • Host_business_num — INTEGER
  • Host_mailOrder_num — INTEGER
  • Host_account_num — INTEGER

Inquiry

  • Inquiry_num — INTEGER — Primary key — NOT NULL
  • User_num — INTEGER — Foreign key → User.User_num — NOT NULL — AUTO_INCREMENT
  • Inquiry_title — VARCHAR(255)
  • Inquiry_text — VARCHAR(255)
  • Inquiry_category — VARCHAR(255)
  • Inquiry_making_time — DateTime

Inquiry_jpg

  • Inquiry_jpg_num — INTEGER — Primary key — NOT NULL
  • Inquiry_num — INTEGER — Foreign key → Inquiry.Inquiry_num — NOT NULL
  • Inquiry_origin_name — VARCHAR(255)
  • Inquiry_path — VARCHAR(255)
  • Inquiry_jpg_name — VARCHAR(255)

Inquiry_reply

  • Inquiry_reply_num — INTEGER — Primary key — NOT NULL
  • Inquiry_num — INTEGER — Foreign key → Inquiry.Inquiry_num — NOT NULL
  • Reply_user_num — INTEGER — Foreign key → User.User_num — NOT NULL — AUTO_INCREMENT
  • Inquiry_reply_text — VARCHAR(255)
  • Inquiry_reply_date — DateTime

List_Personal_Score (List_personal_score)

  • Score_num — INTEGER — Primary key — NOT NULL
  • Play_list_num — INTEGER — Foreign key → SetList_pdf.Play_list_num — NOT NULL
  • Personal_interval_num — INTEGER
  • Personal_ beat_num — INTEGER
  • Personal_performance_num — INTEGER

PR_Booking

  • Booking_num — INTEGER — Primary key — NOT NULL
  • PR_num — INTEGER — Foreign key → PracticeRoom.PR_num — NOT NULL
  • User_num — INTEGER — Foreign key → User.User_num — NOT NULL — AUTO_INCREMENT
  • Booking_Date — VARCHAR(255)
  • Booking_total_person — INTEGER
  • Booking_total_price — INTEGER
  • Booking_using_time — DateTime
  • Booking_payment_method — VARCHAR(255)
  • Booking_payment_status — VARCHAR(255) — 결제 상태 여부(결제 완료 OR 취소)파악

PR_Detail

  • PR_num — INTEGER — Foreign key → PracticeRoom.PR_num — NOT NULL
  • PR_address — VARCHAR(255)
  • PR_shareDevice — VARCHAR(255) — 기본 제공 아이템들
  • PR_warnings — VARCHAR(255) — 사용시 주의사항
  • PR_parking — VARCHAR
  • PR_rule — VARCHAR(255)
  • PR_max_person — INTEGER

PR_Review

  • Review_num — INTEGER — Primary key — NOT NULL
  • PR_num — INTEGER — Foreign key → PracticeRoom.PR_num — NOT NULL
  • User_num — INTEGER — Foreign key → User.User_num — NOT NULL — AUTO_INCREMENT
  • Review_date — DateTime
  • Review_text — VARCHAR(255)
  • Review_star_score — INTEGER

PR_jpg

  • PR_jpg_num — INTEGER — Primary key — NOT NULL
  • PR_num — INTEGER — Foreign key → PracticeRoom.PR_num — NOT NULL
  • PR_jpg_origin_name — VARCHAR(255) — 파일이 업로드될 때 본명
  • PR_jpg_path — VARCHAR(255)
  • PR_jpg_name — VARCHAR(255) — 파일이 다운로드될 때 변경될 명

PracticeRoom

  • PR_num (PK) — INTEGER — Primary key — NOT NULL
  • User_num (FK) — INTEGER — Foreign key → User.User_num — NOT NULL — AUTO_INCREMENT
  • PR_name (Field) — VARCHAR(255)
  • PR_price (Field4) — INTEGER
  • PR_category (Field2) — VARCHAR(255)
  • PR_useable (Field3) — VARCHAR(255) — 등록 장소 대여 가능&중지&중지해제요청(수정필요)

SetList_pdf

  • Play_list_num (PK) — INTEGER — Primary key — NOT NULL
  • List_num (Key) — INTEGER — Foreign key → Set_List.List_num — NOT NULL
  • List_jpg_origin_name (Field) — VARCHAR(255) — 파일이 업로드될 때 본명
  • List_pdf_path (Field2) — VARCHAR(255)
  • List_pdf_name (Field3) — VARCHAR(255) — 파일이 다운로드될 때 변경될 명

Set_List

  • List_num — INTEGER — Primary key — NOT NULL
  • User_num — INTEGER — Foreign key → User.User_num — NOT NULL — AUTO_INCREMENT
  • List_title — VARCHAR(255)
  • List_category — VARCHAR(255)
  • Team_interval_num — INTEGER
  • Team_beat_num — INTEGER
  • Team_performance — INTEGER

User

  • User_num (PK) — INTEGER — Primary key — NOT NULL — AUTO_INCREMENT
  • User_Id (Field) — VARCHAR(255)
  • User_pwd (Field2) — VARCHAR(255)
  • User_email (Field3) — VARCHAR(255)
  • User_rights (Field4) — VARCHAR(255)
  • User_name (Field5) — VARCHAR(255)