sechan_dev

Tables (8)

SC_BOARD (Untitled2)

  • BOARD_NO (Key) — Primary key — NOT NULL
  • TITLE (Field)
  • CONTENT (Field2)
  • CREATE_DT (Field3)
  • UPDATE_DT (Field4)
  • PWD (Field6)
  • DEL_YN (Field5)

SC_BOARD_COMMENT (Untitled6)

  • COMMENT_NO (Key) — Primary key — NOT NULL
  • CONTENT (Field)
  • CREATE_DT (Field2)
  • DEL_YN (Field3)
  • BOARD_NO (Key2) — Foreign key → SC_BOARD.BOARD_NO — NOT NULL

SC_FAQ (Untitled)

  • FAQ_NO (Key) — Primary key — NOT NULL
  • TITLE (Field)
  • CONTENT (Field2)
  • CREATE_DT (Field3)
  • UPDATE_DT (Field4)
  • DEL_YN (Field5)

SC_FILEINFO (Untitled7)

  • FILE_NO (Key) — Primary key — NOT NULL
  • FILE_ORIGINNAME (Field)
  • FILE_CHANGEDNAME (Field2)
  • DOWNLOAD_COUNT (Field3)
  • DEL_YN (Field4)
  • REF_NO (Key2) — Foreign key → SC_REFERENCE.REF_NO — NOT NULL

SC_NOTICE (Untitled4)

  • NOTICE_NO (Key) — Primary key — NOT NULL
  • TITLE (Field)
  • CONTENT (Field2)
  • CREATE_DT (Field3)
  • UPDATE_DT (Field4)
  • DEL_YN (Field5)

SC_QNA (Untitled3)

  • QNA_NO (Key) — Primary key — NOT NULL
  • TITLE (Field)
  • CONTENT (Field2)
  • EMAIL (Field4)
  • CREATE_DT (Field3)
  • UPDATE_DT (Field6)
  • PWD (Field5)
  • DEL_YN (Field7)

SC_QNA_MAIL_LOG (Untitled8)

  • QNA_NO (Key) — Foreign key → SC_QNA.QNA_NO — NOT NULL
  • TITLE (Field)
  • CONTENT (Field2)
  • SENDER_ADDRESS (Field3)
  • CREATE_DT (Field4)
  • SEND_RESULT (Field5)
  • RECEIVER_ADDRESS (Field6)

SC_REFERENCE (Untitled5)

  • REF_NO (Key) — Primary key — NOT NULL
  • TITLE (Field)
  • CONTENT (Field2)
  • CREATE_DT (Field3)
  • UPDATE_DT (Field4)
  • DEL_YN (Field5)