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)