ERD_GROUPWARE_VET
Tables (20)
ANIMAL (Untitled7)
- ANIM_NO — INT — Primary key — NOT NULL
- ANIM_NAME — VARCHAR2(20)
- ANIM_SPECIES — VARCHAR2(100)
- ANIM_BDATE — DATE
- ANIM_SEX — VARCHAR2(20)
- ANIM_WEIGHT — NUMBER
- MEMBER_NO — INT — Foreign key → USER.USER_NO — NOT NULL
APPROVAL (Untitled13)
- APP_NO — INT — Primary key — NOT NULL
- APP_TITLE — VARCHAR2(100)
- APP_CONTENT — VARCHAR2(2000)
- APP_DATE — DATE
- APP_STATEMENT — VARCHAR2(100)
- MEMBER_NO — INT — Foreign key → USER.USER_NO — NOT NULL
ATTACHED (CopyOfUntitled3)
- ATTACHED_NO — INT — Primary key — NOT NULL
- ATTACHED_NAME — VARCHAR2(200)
- ATTACHED_BYTE — NUMBER
- ATTACHED_ROUTE (PICTURES_ROUTE) — VARCHAR2(200)
- BOARD_NOTICE_NO — INT — Foreign key → BOARD_NOTICE.BOARD_NOTICE_NO — NOT NULL
- APP_NO — INT — Foreign key → APPROVAL.APP_NO — NOT NULL
BOARD_FREE (Untitled12)
- BOARD_FREE_NO — INT — Primary key — NOT NULL
- BOARD_FREE_TITLE — VARCHAR2(20)
- BOARD_FREE_CONTENT — VARCHAR2(2000)
- BOARD_FREE_HITS — INT
- BOARD_FREE_THUMBSUP — INT
- MEMBER_NO — INT — Foreign key → USER.USER_NO — NOT NULL
BOARD_FREE_COMMENT (CopyOfUntitled42)
- BOARD_FREE_COMMENT_NO — INT — Primary key — NOT NULL
- BOARD_FREE_COMMENT_WRITER — VARCHAR2(20)
- BOARD_FREE_COMMENT_DATE — DATE
- BOARD_FREE_COMMENT_CONTENT — VARCHAR2(1000)
- BOARD_FREE_NO — INT — Foreign key → BOARD_FREE.BOARD_FREE_NO — NOT NULL
BOARD_NOTICE (CopyOfUntitled2)
- BOARD_NOTICE_NO — INT — Primary key — NOT NULL
- BOARD_NOTICE_TITLE — VARCHAR2(100)
- BOARD_NOTICE_CONTENT — VARCHAR2(2000)
- BOARD_NOTICE_HITS — INT
- MEMBER_NO — INT — Foreign key → USER.USER_NO — NOT NULL
BOARD_NOTICE_COMMENT (CopyOfUntitled4)
- BOARD_NOTICE_COMMENT_NO — INT — Primary key — NOT NULL
- BOARD_NOTICE_COMMENT_WRITER — VARCHAR2(20)
- BOARD_NOTICE_COMMENT_DATE — DATE
- BOARD_NOTICE_COMMENT_CONTENT — VARCHAR2(1000)
- BOARD_NOTICE_NO — INT — Foreign key → BOARD_NOTICE.BOARD_NOTICE_NO — NOT NULL
BOARD_REVIEW (Untitled11)
- REVIEW_NO — INT — Primary key — NOT NULL
- REVIEW_CONTENT — VARCHAR2(1000)
- REVIEW_HITS — INT
- REVIEW_THUMBSUP — INT
BOARD_SCHEDULE (CopyOfCopyOfUntitled2)
- BOARD_SCHEDULE_NO — INT — Primary key — NOT NULL
- BOARD_SCHEDULE_TITLE — VARCHAR2(100)
- BOARD_SCHEDULE_CONTENT — VARCHAR2(2000)
- BOARD_SCHEDULE_HITS — INT
- MEMBER_NO — INT — Foreign key → USER.USER_NO — NOT NULL
- BOARD_SCHEDULE_STARTDATE — DATE
- BOARD_SCHEDULE_ENDDATE — DATE
BOARD_TIPS (Untitled2)
- BOARD_TIPS_NO — INT — Primary key — NOT NULL
- BOARD_TIPS_TITLE — VARCHAR2(100)
- BOARD_TIPS_CONTENT — VARCHAR2(2000)
- MEMBER_NO — INT — Foreign key → USER.USER_NO — NOT NULL
- BOARD_TIPS_HITS — INT
- BOARD_TIPS_THUMBSUP — INT
BOARD_TIPS_COMMENT (Untitled4)
- BOARD_TIPS_COMMENT_NO — INT — Primary key — NOT NULL
- BOARD_TIPS_COMMENT_WRITER — VARCHAR2(20)
- BOARD_TIPS_COMMENT_DATE — DATE
- BOARD_TIPS_COMMENT_CONTENT — VARCHAR2(1000)
- BOARD_TIPS_NO — INT — Foreign key → BOARD_TIPS.BOARD_TIPS_NO — NOT NULL
COMMON_CODE
- COMMON_CODE_NO — INT — Primary key — NOT NULL
- COMMON_CODE_NAME — VARCHAR(30)
Copy Of MEMBER (MEMBER)
- MEMBER_NO — INT — Primary key — NOT NULL
- MEMBER_ID — VARCHAR2(30)
- MEMBER_PW — VARCHAR2(100)
- MEMBER_NAME — VARCHAR2(12)
- MEMBER_PHONENUM — VARCHAR2(39)
- MEMBER_ADDRESS — VARCHAR2(90)
- MEMBER_EMAIL — VARCHAR2(100)
- MEMBER_BDATE — VARCHAR2(30)
- MEMBER_ROLE_NO — INT — Foreign key → COMMON_CODE.COMMON_CODE_NO — NOT NULL
DIAGNOSIS (Untitled8)
- DIAG_NO — INT — Primary key — NOT NULL
- DIAG_SYMPTOM — VARCHR2(20)
- DIAG_DATE — DATE
- MEMBER_NO — INT — Foreign key → EMPLOYEE_JOB.MEMBER_NO — NOT NULL
- ANIM_NO — INT — Foreign key → ANIMAL.ANIM_NO — NOT NULL
- RESERVATION_NO — INT — Foreign key → RESERVATION.RESERVATION_NO — NOT NULL
EMPLOYEE_JOB (Untitled6)
- MEMBER_NO — INT — Foreign key → USER.USER_NO — NOT NULL
- EMPLOYEE_JOB_CATEGORY — VARCHAR2(100)
- EMPLOYEE_WORK_STARTTIME — DATE
- EMPLOYEE_WORK_ENDTIME — DATE
EMP_ATTENDANCE (Untitled10)
- ATTENDANCE_NO — INT — Primary key — NOT NULL
- ATTENDANCE_STARTDATE — DATE
- ATTENDANCE_ENDDATE — DATE
- MEMBER_NO — INT — Foreign key → USER.USER_NO — NOT NULL
ITEM (Untitled9)
- ITEM_NO — INT — Primary key — NOT NULL
- ITEM_NAME — VARCHAR2(200)
- ITEM_NOWINVENTORY — INT
- ITEM_MININVENTORY — INT
- ITEM_PRICE — INT
- ITEM_PRODUCED_COMPANY — VARCHAR2(100)
- ITEM_STORED_DATE (ITEM_STORED_DATED) — DATE
- ITEM_DISCOUNT — NUMBER
PICTURES (Untitled3)
- PICTURES_NO — INT — Primary key — NOT NULL
- PICTURES_NAME — VARCHAR2(200)
- PICTURES_BYTE — NUMBER
- PICTURES_ROUTE — VARCHAR2(200)
- REVIEW_NO — INT — Foreign key → BOARD_REVIEW.REVIEW_NO
- BOARD_TIPS_NO — INT — Foreign key → BOARD_TIPS.BOARD_TIPS_NO
- BOARD_NOTICE_NO — INT — Foreign key → BOARD_NOTICE.BOARD_NOTICE_NO — NOT NULL
- BOARD_FREE_NO — INT — Foreign key → BOARD_FREE.BOARD_FREE_NO — NOT NULL
- BOARD_FREE_NO (BOARD_FREE_NO2) — INT — Foreign key → BOARD_FREE.BOARD_FREE_NO — NOT NULL
RESERVATION (Untitled5)
- RESERVATION_NO — INT — Primary key — NOT NULL
- RESERVATION_STARTDATE — DATE
- RESERVATION_ENDDATE — DATE
- RESERATION_TYPE (RESERVATION_TYPE) — VARCHAR2(50)
- RESERVATION_ETCETERA — VARCHAR2(2000)
- RESERVATION_BEFOREAFTER — VARCHAR2(20)
- MEMBER_NO — INT — Foreign key → EMPLOYEE_JOB.MEMBER_NO — NOT NULL
- ANIM_NO — INT — Foreign key → ANIMAL.ANIM_NO — NOT NULL
USER
- USER_NO — INT — Primary key — NOT NULL
- USER_ID — VARCHAR2(30)
- USER_PW — VARCHAR2(100)
- USER_NAME — VARCHAR2(12)
- USER_PHONENUM — VARCHAR2(13)
- USER_ADDRESS — VARCHAR2(90)
- USER_EMAIL — VARCHAR2(100)
- USER_BDATE — VARCHAR2(30)
- USER_ROLE_NO — INT — Foreign key → COMMON_CODE.COMMON_CODE_NO — NOT NULL