test
Tables (14)
Account
- account_id — VARCHAR(255) — Primary key — NOT NULL
- bank_name — VARCHAR(255)
- created_date — DATE
- updated_date — DATE
- user_email — VARCHAR(255) — NOT NULL
Dentistry
- den_id — VARCHAR(255) — Primary key — NOT NULL
- den_name — VARCHAR(255) — NOT NULL
- den_address — VARCHAR(255) — NOT NULL
- specialty — VARCHAR(255)
- den_tel — VARCHAR(255) — NOT NULL
- day_openhours — TIME — NOT NULL
- day_closehours — TIME — NOT NULL
- end_openhours — TIME
- end_closehours — TIME
- den_score — DECIMAL(3, 2)
- treat_type — VARCHAR(255)
- lunch_time — VARCHAR(255)
- den_comment — VARCHAR(255)
Doctor
- doc_id — INT — Primary key — NOT NULL
- doc_name — VARCHAR(255) — NOT NULL
- cre_doc — DATE — NOT NULL
- den_id — VARCHAR(255) — NOT NULL
FamilyAccount
- family_id — VARCHAR(255) — Primary key — NOT NULL
- user_email — VARCHAR(255) — Primary key — NOT NULL
Manager
- manager_id — VARCHAR(255) — Primary key — NOT NULL
- den_id — VARCHAR(255) — NOT NULL
- manager_name — VARCHAR(255) — NOT NULL
- manager_tel — VARCHAR(255) — NOT NULL
- manager_email — VARCHAR(255)
- manager_authority — VARCHAR(255) — NOT NULL
Mapping
- map_id — INT — Primary key — NOT NULL
- den_id — VARCHAR(255) — NOT NULL
- user_email — VARCHAR(255) — NOT NULL
OtherMapping
- other_key — VARCHAR(255) — Primary key — NOT NULL
- user_email — VARCHAR(255) — Primary key — NOT NULL
Payment
- pay_id — INT — Primary key — NOT NULL
- pay_amount — INT — NOT NULL
- pay_method — VARCHAR(255)
- payment_date — DATETIME
- pay_status — VARCHAR(255) — NOT NULL
- is_refunded — BOOLEAN — NOT NULL
- refund_date — DATETIME
Record
- record_id — INT — Primary key — NOT NULL
- user_email — VARCHAR(255) — NOT NULL
- symptom — VARCHAR(255)
- diag_result — VARCHAR(255)
- treat_method — VARCHAR(255)
- rec_date — DATETIME
Reservation
- reservation_id — VARCHAR(255) — Primary key — NOT NULL — 예약일+방문자수(카운트), 12자리로 구성
- content — VARCHAR(255)
- doc_id — INT — NOT NULL
- reservation_date — DATETIME
- den_id — VARCHAR(255) — NOT NULL
- user_email — VARCHAR(255) — NOT NULL
Treatment
- treat_id — VARCHAR(255) — Primary key — NOT NULL — 병원코드 + 이메일
- treat_content — VARCHAR(255)
- den_id — VARCHAR(255) — NOT NULL
- user_email — VARCHAR(255) — NOT NULL
TreatmentMapping
- treat_num — INT — Primary key — NOT NULL
- user_email — VARCHAR(255) — Primary key — NOT NULL
User
- user_email — VARCHAR(255) — Primary key — NOT NULL — 사용자 아이디
- user_name — VARCHAR(255) — NOT NULL
- user_tel — VARCHAR(255) — NOT NULL
- user_birth — DATE — NOT NULL
- kakao_id — VARCHAR(255)
- google_id — VARCHAR(255)
- cre_user — DATE — NOT NULL
- log — DATE — NOT NULL
- user_addr — VARCHAR(255) — NOT NULL — 사용자 상세주소
- user_zip — INT — NOT NULL — 사용자 우편번호
Whitening
- user_email — VARCHAR(255) — Primary key — NOT NULL
- whi_url — VARCHAR(255)
- result — VARCHAR(255)
- score — DECIMAL(5, 2)