CONSUPPORT-board

Tables (4)

ABOARD

  • USER_ID (userId) — VARCHAR2(100) — Foreign key → User.USER_ID — NOT NULL
  • QBOARD_NUM (qboardNum) — NUMBER — Foreign key → QBOARD.QBOARD_NUM — NOT NULL
  • ANSWER (answer) — VARCHAR2(100) — NOT NULL
  • ANSWER_DATE (answerDate) — DATE

QBOARD

  • QBOARD_NUM (qboardNum) — NUMBER — Primary key — NOT NULL
  • USER_ID (userId) — VARCHAR2(100) — Foreign key → User.USER_ID — NOT NULL
  • QBOARD_TITLE (qboardTitle) — VARCHAR2(100) — NOT NULL
  • QBOARD_CONTENT (qboardContent) — VARCHAR2(100) — NOT NULL
  • QBOARD_CREATE_DATE (qboardCreateDate) — DATE
  • Q_SECRET (qsecret) — VARCHAR2(50)

Untitled

    User

    • USER_ID (userId) — VARCHAR2(100) — Primary key — NOT NULL
    • USER_PW (userPw) — VARCHAR2(100) — NOT NULL
    • USER_NAME (userName) — VARCHAR2(100) — NOT NULL
    • USER_ADDR (userAddr) — VARCHAR2(100) — NOT NULL
    • USER_ADDR_DETAIL (userAddrDetail) — VARCHAR2(100)
    • USER_BIRTH (userBirth) — VARCHAR2(100) — NOT NULL
    • USER_TELL (userTell) — VARCHAR2(100) — NOT NULL
    • USER_ROLE (userRole) — VARCHAR2(20) — NOT NULL
    • USER_STATUS (userStatus) — VARCHAR2(20) — NOT NULL