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