SJ adopt center

Tables (5)

COMMENTS (comments)

  • COMMENTS NUMBER (NUM) — number — Primary key — NOT NULL
  • COMMENTS NUMBER (BNO) — number
  • COMMENTS WRITER (WRITER) — varchar2
  • COMMENTS CONTENT (CONTENT) — varchar2
  • COMMENTS DATE (WDATE) — DATE

ENTER (enter)

  • ENTER NUMBER (BNO) — number — Primary key — NOT NULL
  • ENTER TITLE (TITLE) — varchar2
  • ENTER NAME (NAME) — varchar2
  • ENTER CONTENT (CONTENT) — varchar2
  • ENTER VIEWCOUNT (VEWCOUNT) — NUMBER
  • ENTER INDATE (REGDATE) — DATE
  • ENTER IMAGE (IMGURL) — varchar2
  • ENTER STATUS (STATUS) — varchar2
  • ENTERED DATE (ENTERDATE) — DATE

JOINMEMBER (joinmember)

  • USER NUMBER (BNO) — NUMBER — Primary key — NOT NULL
  • USER ID (ID) — varchar2
  • USER PASSWORD (PW) — varchar2
  • USER NAME (NAME) — varchar2
  • USER BIRTHDAY (BUIRTH) — varchar2
  • USER GENDER (GENDER) — char
  • USER EMAIL (EMAIL) — varchar2
  • USER PHONE (PHONE) — varchar2

NEWS (news)

  • NEWS NUMBER (BNO) — number — Primary key — NOT NULL
  • NEWS TITLE (TITLE) — varchar2
  • NEWS CONTENT (CONTENT) — varchar2
  • NEWS INDATE (REGDATE) — DATE
  • NEWS VIEWCOUNT (VIEWCOUNT) — NUMBER
  • NEWS IMAGE (IMGURL) — varchar2
  • NEWS WRITER (NAME) — varchar2

Untitled

  • Key — Primary key — NOT NULL