hair
Tables (10)
ADMIN_LOG
- LOG_ID — NUMBER
- ADMIN_ID — VARCHAR2(50 BYTE)
- ACTION_TYPE — VARCHAR2(50 BYTE)
- ACTION_DESC — VARCHAR2(1000 BYTE)
- ACTION_DATE — DATE
COMMUNITY_COMMENT
- COMMENT_ID — NUMBER
- POST_ID — NUMBER — Foreign key → COMMUNITY_POST.POST_ID
- MEMBER_ID — VARCHAR2(50 BYTE) — Foreign key → MEMBER.MEMBER_ID
- COMMENT_TEXT — VARCHAR2(1000 BYTE)
- COMMENT_DATE — DATE
COMMUNITY_POST
- POST_ID — NUMBER
- MEMBER_ID — VARCHAR2(50 BYTE) — Foreign key → MEMBER.MEMBER_ID
- TITLE — VARCHAR2(200 BYTE)
- CONTENT — CLOB
- CATEGORY — VARCHAR2(50 BYTE)
- ATTACH_FILE — VARCHAR2(300 BYTE)
- LINK_URL — VARCHAR2(300 BYTE)
- POST_DATE — DATE
- VIEWS — NUMBER
FEEDBACK
- FEEDBACK_ID — NUMBER
- MEMBER_ID — VARCHAR2(50 BYTE)
- TITLE — VARCHAR2(200 BYTE)
- CONTENT — CLOB
- CREATED_DATE — DATE
- REPLY_STATUS — VARCHAR2(20 BYTE)
HAIR_BANK
- BANK_ID — NUMBER
- NAME — VARCHAR2(100 BYTE)
- ADDRESS — VARCHAR2(200 BYTE)
- PHONE — VARCHAR2(30 BYTE)
- INFO — VARCHAR2(4000 BYTE)
- REG_DATE — DATE
HAIR_TEST_RESULT
- TEST_ID — NUMBER
- MEMBER_ID — VARCHAR2(50 BYTE) — Foreign key → MEMBER.MEMBER_ID
- TEST_DATE — DATE
- IMAGE_PATH — VARCHAR2(200 BYTE)
- RESULT_STAGE — NUMBER
- RECOMMEND_TEXT — CLOB
HOSPITAL
- HOSPITAL_ID — NUMBER
- NAME — VARCHAR2(100 BYTE)
- ADDRESS — VARCHAR2(200 BYTE)
- PHONE — VARCHAR2(30 BYTE)
- LAT — NUMBER
- LNG — NUMBER
- DESCRIPTION — VARCHAR2(4000 BYTE)
- REG_DATE — DATE
MEMBER
- MEMBER_ID — VARCHAR2(50 BYTE)
- PASSWORD — VARCHAR2(100 BYTE)
- NAME — VARCHAR2(50 BYTE)
- EMAIL — VARCHAR2(100 BYTE)
- PHONE — VARCHAR2(20 BYTE)
- GENDER — VARCHAR2(10 BYTE)
- AGE — NUMBER
- REGION — VARCHAR2(100 BYTE)
- JOIN_DATE — DATE
- ROLE — VARCHAR2(20 BYTE)
RECOMMEND_MEDICINE
- MEDICINE_ID — NUMBER
- STAGE — NUMBER
- NAME — VARCHAR2(100 BYTE)
- DESCRIPTION — VARCHAR2(1000 BYTE)
- PRICE — NUMBER
- LINK_URL — VARCHAR2(300 BYTE)
REPORT
- REPORT_ID — NUMBER
- REPORT_TYPE — VARCHAR2(20 BYTE)
- TARGET_ID — NUMBER
- MEMBER_ID — VARCHAR2(50 BYTE)
- REASON — VARCHAR2(500 BYTE)
- REPORT_DATE — DATE
- STATUS — VARCHAR2(20 BYTE)