ADVICE_BASIC
Description:
The ADVICE_BASIC table contains the basic information like name, record status of each care advice record.

Primary Key
Column Name Ordinal Position
CARE_ADVICE_ID 1

Column Information
Name Type Discontinued?
1 CARE_ADVICE_ID NUMERIC No
The ID for the care advice given to a patient.
2 CARE_ADVICE_NAME VARCHAR No
The name of the care advice record.