SoSoSchool
Tables (9)
GIFT_BOARD
- GI_NO — NUMBER — Primary key
- GI_TITLE — VARCHAR2(100) — NOT NULL
- GI_PRIZE — NUMBER — NOT NULL
- GI_STOCK — NUMBER — NOT NULL
- GI_IMG — VARCHAR2(100) — NOT NULL
NOTICE
- NOTI_NO — NUMBER — Primary key
- NOTI_GNO — NUMBER — NOT NULL
- NOTI_GSQ — NUMBER — NOT NULL
- NOTI_TAB — NUMBER — NOT NULL
- NOTI_TITLE — VARCHAR2(2000)NOT — NOT NULL
- NOTI_WRITER — VARCHAR2(30) — NOT NULL
- NOTI_CONTENT — VARCHAR2(4000) — NOT NULL
- NOTI_REGDATE — DATE — NOT NULL
QNA
- QNA_NO — NUMBER — Primary key
- USER_NO — NUMBER — Foreign key → SOSO_USER.USER_NO
- QNA_GNO — NUMBER — NOT NULL
- QNA_GSQ — NUMBER — NOT NULL
- QNA_TAB — NUMBER — NOT NULL
- QNA_TITLE — VARCHAR2(2000)NOT — NOT NULL
- QNA_WRITER — VARCHAR2(30) — NOT NULL
- QNA_CONTENT — VARCHAR2(4000) — NOT NULL
- QNA_REGDATE — DATE — NOT NULL
REF_BOARD
- RBOARD_NO — NUMBER — Primary key
- RBOARD_TITLE — VARCHAR2(2000) — NOT NULL
- RBOARD_CONTENT — VARCHAR2(4000) — NOT NULL
- RBOARD_REGDATE — DATE — NOT NULL
- RBOARD_GRADE — NUMBER — NOT NULL
- RBOARD_SUBJECT — VARCHAR2(30) — NOT NULL
- RBOARD_TYPE — VARCHAR2(30) — NOT NULL
RESULT_ENG
- USER_ID — VARCHAR2(30) — Primary key — NOT NULL
- USER_NO — NUMBER — Foreign key → SOSO_USER.USER_NO
- MONTH — NUMBER — NOT NULL
- DAY — NUMBER — NOT NULL
- ENG — NUMBER — NOT NULL
RESULT_KOR
- USER_ID — VARCHAR2(30) — Primary key — NOT NULL
- USER_NO — NUMBER — Foreign key → SOSO_USER.USER_NO
- MONTH — NUMBER — NOT NULL
- DAY — NUMBER — NOT NULL
- KOR — NUMBER — NOT NULL
RESULT_MATH
- USER_ID — VARCHAR2(30) — Primary key — NOT NULL
- USER_NO — NUMBER — Foreign key → SOSO_USER.USER_NO
- MONTH — NUMBER — NOT NULL
- DAY — NUMBER — NOT NULL
- MATH — NUMBER — NOT NULL
SMALL_GROUP
- GBOARD_NO — NUMBER — Primary key — NOT NULL
- USER_NO — NUMBER — Foreign key → SOSO_USER.USER_NO
- GBOARD_TITLE — VARCHAR2(100) — NOT NULL
- GBOARD_SUBTITLE — VARCHAR2(100) — NOT NULL
- GBOARD_CONTENT — VARCHAR2(4000) — NOT NULL
- GBOARD_IMG — VARCHAR2(100) — NOT NULL
- GBOARD_REGDATE — DATE — NOT NULL
- GBOARD_REGION — VARCHAR2(200) — NOT NULL
- GBOARD_LiBRARY — VARCHAR2(200) — NOT NULL
SOSO_USER
- USER_NO — NUMBER — Primary key
- USER_PR — VARCHAR2(30) — NOT NULL
- USER_NAME — VARCHAR2(30)NOT — NOT NULL
- USER_ID — VARCHAR(20) — NOT NULL
- USER_PW — VARCHAR(100) — NOT NULL
- GRADE — NUMBER — NOT NULL
- POSTCODE — VARCHAR2(100) — NOT NULL
- ROADADDR — VARCHAR2(4000) — NOT NULL
- DETAILADDR — VARCHAR2(4000) — NOT NULL
- PHONE — VARCHAR2(200) — NOT NULL
- EMAIL — VARCHAR2(1000) — NOT NULL
- USER_POINT — NUMBER — NOT NULL
- USER_STAR — NUMBER — NOT NULL
- SUB_YN — CHAR(1) — NOT NULL
- ENABLED_YN — CHAR(1) — NOT NULL
- USER_TYPE — VARCHAR2(5) — NOT NULL
- REGION — VARCHAR2(100) — NOT NULL