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