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)