capSV

Tables (11)

CHATTING (Untitled)

  • Key (CHATTING_NUMBER) — int — Primary key — NOT NULL
  • Field (CHATTING_TITLE) — VARCHAR(10)
  • Field (CHATTING_IMAGE)
  • Field (CHATTING_ENROLL_DATE)

CHATTING_MEMBER (Untitled2)

  • Key (CHATTING_MEMBER_NUMBER) — Primary key — NOT NULL
  • Field (CHATTING_MEMBER_CHATTING_NUMBER) — int — Foreign key → CHATTING.Key — NOT NULL
  • Key (CHATTING_MEMBER_STAFF_NUMBER) — Foreign key → STAFF.Key — NOT NULL

CONTENT (Untitled5)

  • Key (CONTENT_NUMBER) — Primary key — NOT NULL
  • Field (CONTENT_CONTENT)
  • Field (CONTENT_ENROLL_DATE)
  • Key (CONTENT_CHATTING_NUMBER) — int — Foreign key → CHATTING.Key — NOT NULL
  • Key (CONTENT_REQUEST_NUMBER) — Foreign key → REQUEST.Key — NOT NULL
  • Key (CONTENT_STAFF_NUMBER) — Foreign key → STAFF.Key — NOT NULL

ENTERPRISE (Untitled4)

  • Key (ENTERPRISE_NUMBER) — Primary key — NOT NULL
  • Field (ENTERPRISE_BUSINESS_NUMBER)
  • Field (ENTERPRISE_NAME)
  • Field (ENTERPRISE_CONTACT_NUMBER)
  • Field (ENTERPRISE_REGISTER_DATE)

NOTICE (Untitled6)

  • Key (NOTICE_NUMBER) — Primary key — NOT NULL
  • Field (NOTICE_TITLE)
  • Field (NOTICE_CONTENT)
  • Field (NOTICE_ENROLL_DATE)

NOTICE_ATTACHMENT (Untitled7)

  • Key (NOTICE_ATTACHMENT_NUMBER) — Primary key — NOT NULL
  • Field (NOTICE_ATTACHMENT_ATTACHMENT)
  • Key (NOTICE_NUMBER) — Foreign key → NOTICE.Key — NOT NULL

REQUEST (Untitled8)

  • Key (REQUEST_NUMBER) — Primary key — NOT NULL
  • Field (REQUEST_STATUS)
  • Field (REQUEST_SIZE)
  • Field (REQUEST_PROVINCE)
  • Field (REQUEST_REGION)
  • Field (REQUEST_QUANTITY)
  • Field (REQUEST_TIME)
  • Field (REQUEST_WEIGHT)
  • Field (REQUEST_LINE)
  • Field (REQUEST_SOURCE)
  • Field (REQUEST_DESTINATION)
  • Field (REQUEST_TRADE)
  • Field (REQUEST_CLASSFICATION)
  • Field (REQUEST_ENROLL_DATE)
  • Field (REQUEST_NOTE)
  • Key (STAFF_NUMBER) — Foreign key → STAFF.Key — NOT NULL

STAFF (Untitled3)

  • Key (STAFF_NUMBER) — Primary key — NOT NULL
  • Field (STAFF_NAME)
  • Field (STAFF_ID)
  • Field (STAFF_PASSWORD)
  • Field (STAFF_RIGISTER_DATE)
  • Key (STAFF_ENTERPRISE_NUMBER) — Foreign key → ENTERPRISE.Key — NOT NULL

STAFF_IMAGE (Untitled11)

  • Key (STAFF_IMAGE_NUMBER) — Primary key — NOT NULL
  • Key (STAFF_IMAGE_STAFF_NUMBER) — Foreign key → STAFF.Key — NOT NULL
  • Field (STAFF_IMAGE_IMAGE)
  • Field (STAFF_IMAGE_REPRESENTATION)

TEAM (Untitled9)

  • Key (TEAM_NUMBER) — Primary key — NOT NULL
  • Field (TEAM_ENROLL_DATE)
  • Field (TEAM_NAME)

TEAM_MEMBER (Untitled10)

  • Key (TEAM_MEMBER_NUMBER) — Primary key — NOT NULL
  • Key (TEAM_NUMBER) — Foreign key → TEAM.Key — NOT NULL
  • Key (STAFF_NUMBER) — Foreign key → STAFF.Key — NOT NULL