Chinese Medical & Dental Practice Management System (1.1M)
Patient records, including information such as phone numbers, patient type, names, birthdates, and various identifiers used within a medical & dental practice management system. Here's a breakdown of the fields:
Field Breakdown
- phoneNumber1: Primary contact number of the patient.
- patientType: The classification of the patient (e.g., "普通" which means "General").
- name: The patient's full name.
- point: Could represent loyalty points or other point-based tracking in the system.
- mobile: Mobile phone number of the patient.
- notes: Additional notes related to the patient's condition or visit.
- onlineConsultantId: Identifier for an online consultant who may be associated with the patient.
- birth: Date of birth of the patient.
- sex: Gender of the patient (e.g., 1 for male).
- officeId: Identifier for the office or branch where the patient is registered.
- tenantId: Identifier for the tenant or organization managing the data.
- nameCode: Code representing the patient's name, possibly for indexing or lookup purposes.
- recordCreatedUser: Identifier for the user who created the record.
- isArchived: Indicates whether the record is archived.
- isInactive: Indicates whether the patient is inactive.
- dutyDoctorId: Identifier for the duty doctor associated with the patient.
- privateId: A private identifier, possibly used internally for patient management.
- pictureId: Identifier for the patient's picture in the system.
- id: Unique identifier for the patient record.
- sourceType: Source from which the patient was referred or registered.
- tag: Any tags associated with the patient for categorization.
- firstVisit: Indicates if this was the patient's first visit.
- email: Patient's email address.
- homeAddress: The home address of the patient.
- department: Department within the facility where the patient is treated.
- consultantId: Identifier for the consultant assigned to the patient.
- lastDoctorId: Identifier for the last doctor who treated the patient.
- lastVisit: Date of the last visit to the facility.
- doctorId: Identifier for the current doctor treating the patient.
- membershipId: Membership ID associated with the patient.
- cardNumber: Card number, possibly for insurance or membership.
- otherPrivateId: Another private identifier, similar to privateId.
- phoneNumber2: Secondary contact number of the patient.
- identityCard: Identity card number of the patient.
- phoneNumber3: Tertiary contact number of the patient.
- qq: QQ number, which is a popular instant messaging service in China.
- nickName: Nickname of the patient.
- marketCenterAccount: Account related to marketing or promotions.
- weixin: WeChat ID, a popular messaging app in China.
- phoneNumber4: Quaternary contact number of the patient.
phoneNumber1,patientType,name,point,mobile,notes,onlineConsultantId,birth,sex,officeId,phoneNumber,tenantId,nameCode,recordCreatedUser,isArchived,isInactive,dutyDoctorId,privateId,pictureId,id,sourceType,tag,firstVisit,email,homeAddress,department,consultantId,lastDoctorId,lastVisit,doctorId,membershipId,cardNumber,otherPrivateId,phoneNumber2,identityCard,phoneNumber3,qq,nickName,marketCenterAccount,weixin,phoneNumber4
15267666103,普通,李海龙,0,15267666103,左上5右上5右下45左下45龋坏,0,2012-01-01T00:00:00,1,79,,ec1a67a8-02e2-4a38-9989-b7186543fb6d,lhl,2263,FALSE,TRUE,0,0,0,877250,社务部,,,,,,,,,,,,,,,,,,,,
13958663053,普通,张小燕,0,13958663053,,0,,0,66,,ec1a67a8-02e2-4a38-9989-b7186543fb6d,zxy,649,FALSE,TRUE,0,0,0,1189792,社务部,,,,,,,,,,,,,,,,,,,,
13958706986,普通,项晟铨,0,13958706986,孩子牙齿蛀牙,先到院拍片检查,3623,,1,78,,ec1a67a8-02e2-4a38-9989-b7186543fb6d,xsq,2397,FALSE,TRUE,0,0,0,1225380,户外广告,,,,,,,,,,,,,,,,,,,,