-
-
Save niisar/e6182ef53ed8f1b8772a to your computer and use it in GitHub Desktop.
hms
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| http://mdsfoss.org/hhimsv2/index.php/login | |
| doe | |
| 123 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| create login with hard code ui(admin) pass(admin) | |
| admin = admin/admin | |
| user = demou/demou | |
| doctor = demod/demod |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
------TABLE USER_MST
CREATE TABLE USER_MST
(
USER_CODE INT IDENTITY,
USER_NAME VARCHAR(50),
USER_MAIL VARCHAR(100)
)
------TABLE MAIL_MST
CREATE TABLE MAIL_MST
(
MAIL_CODE INT IDENTITY,
USER_NAME VARCHAR(50),
MAIL_FROM VARCHAR(100),
MAIL_SUB VARCHAR(300),
MAIL_DATE DATETIME,
MAIL_SIZE VARCHAR(20),
MESSAGE_ID VARCHAR(300),
UID INT
)
------TABLE ATTCH_INF
CREATE TABLE ATTCH_INF
(
ATT_ID INT IDENTITY,
ATT_NAME VARCHAR(50),
MESSAGE_ID INT,
UID INT,
ATT_LOC VARCHAR(200)
)
------TABLE ATTCH_RPT_HDR
CREATE TABLE ATTCH_RPT_HDR
(
ARM_ID INT IDENTITY,
ARM_DATE DATETIME,
ARM_BY VARCHAR(100),
ARM_ENTITY VARCHAR(100),
ARM_STACKHOLDER_INF VARCHAR(600),
ARM_CONTACT_DT DATETIME,
ARM_CONTACT_PLACE VARCHAR(600),
ARM_CONTACT_TYPE VARCHAR(50),
ARM_FOR_WHAT VARCHAR(100),
ARM_KEY_PERSON_CONTACT VARCHAR(600),
ARM_OPGL_PARTICIPANT VARCHAR(600),
ARM_EXECUTIVE_SUMMARY VARCHAR(1000),
ARM_MEETING_NOT VARCHAR(1000),
ARM_OUTCOME VARCHAR(100),
ARM_LESSION VARCHAR(1000),
MESSAGE_ID INT,
UID INT
)
------TABLE ATTCH_RPT_DTL
CREATE TABLE ATTCH_RPT_DTL
(
ARD_ID INT IDENTITY,
ARM_ID INT,
ARD_DISTRIBUTION VARCHAR(100),
ARD_ACTION VARCHAR(300)
)