Test
Tables (13)
board
- board_no — INT
- user_id — VARCHAR(20) — NOT NULL
- board_title — VARCHAR(100) — NOT NULL
- board_content — TEXT — NOT NULL
- board_views — INT
- board_date — DATETIME
chat_room
- room_id — INT
- user1_id — VARCHAR(20) — NOT NULL
- user2_id — VARCHAR(20) — NOT NULL
disease
- disease_no — INT
- disease_name — VARCHAR(100) — NOT NULL
disease_tag
- pat_no — INT
- disease_no — INT
field
- field_no — INT
- field_name — VARCHAR(50) — NOT NULL
field_tag
- user_id — VARCHAR(20)
- field_no — INT
message
- message_id — INT
- room_id — INT — NOT NULL
- sender_id — VARCHAR(20) — NOT NULL
- message_content — TEXT — NOT NULL
- create_date — DATETIME
- is_read — TINYINT(1)
patient
- pat_no — INT
- user_id — VARCHAR(20) — NOT NULL
- pat_name — VARCHAR(50) — NOT NULL
- pat_birth — DATE — NOT NULL
- pat_gender — CHAR(1) — NOT NULL
rating
- rating_no — INT
- user_id — VARCHAR(20) — NOT NULL
- rating_score — DECIMAL(3,1) — NOT NULL
- rating_date — DATETIME
reply
- reply_no — INT
- board_no — INT — NOT NULL
- user_id — VARCHAR(20) — NOT NULL
- reply_content — TEXT — NOT NULL
- reply_date — DATETIME
report
- report_no — INT
- user_id — VARCHAR(20) — NOT NULL
- pat_no — INT — NOT NULL
- report_date — DATE — NOT NULL
- report_title — VARCHAR(100) — NOT NULL
- report_content — TEXT — NOT NULL
resume
- resume_no — INT
- user_id — VARCHAR(20) — NOT NULL
- resume_title — VARCHAR(100) — NOT NULL
- resume_content — TEXT — NOT NULL
- resume_file — VARCHAR(200)
- is_opening — TINYINT(1)
- nation — VARCHAR(30)
- desired_date — DATE
- desired_account — DECIMAL(10, 2)
- pat_no — INT
- create_date — DATETIME
- update_date — DATETIME
user
- user_id — VARCHAR(20)
- user_pwd — VARCHAR(30) — NOT NULL
- is_caregiver — TINYINT(1)
- user_name — VARCHAR(50) — NOT NULL
- user_phone — VARCHAR(13) — NOT NULL
- user_address — VARCHAR(100) — NOT NULL
- account_no — VARCHAR(20)
- status — CHAR(1)
- age — INT — NOT NULL