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)
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