CRScube

Tables (3)

MST_BOARD (Untitled2)

  • BOARD_SEQ (board sequence) — Primary key — NOT NULL
  • BOARD_CATE (board category)
  • BOARD_TITLE (board title)
  • BOARD_CONT (board contents)
  • BOARD_VIEW_COUNT (board view count)
  • FILE_SAVE_NAME (file save name)
  • FILE_ORI_NAME (file original name)
  • FILE_PATH (file path)
  • VIDEO_LINK_PATH (video link path)
  • CREATED_AT (created at)
  • CREATED_BY (created by)
  • UPDATED_AT (updated at)
  • UPDATED_BY (updated by)
  • USER_SEQ (user seqence) — integer — Foreign key → MST_USER.USER_SEQ — NOT NULL

MST_SOLUTION (Untitled3)

  • SOL_SEQ (solution sequence) — Primary key — NOT NULL
  • SOL_CATE_FIRST (solution category 1)
  • SOL_CATE_SEC (solution category 2)
  • REQ_NAME (requester name)
  • REQ_COM_NAME (requester company name)
  • REQ_PHONE_NUM (requester phone number)
  • REQ_MSG (requeester message)
  • CREATED_AT (created at)
  • CREATED_BY (created by)
  • UPDATED_AT (updated at)
  • UPDATED_BY (updated by)

MST_USER (Untitled)

  • USER_SEQ (user seqence) — integer — Primary key — NOT NULL
  • USER_EMAIL (user email)
  • USER_PASSWD (user password)
  • USER_GRADE (user grade)
  • USER_NAME (user name)
  • CREATED_AT (created at)
  • CREATED_BY (created by)
  • UPDATED_AT (updated at)
  • UPDATED_BY (updated by)