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