four_forest

Tables (20)

ANIMAL_ALIEN_DISTURB (Untitled16)

  • VARCHAR2(1000) (KOR_NAME)
  • VARCHAR2(1000) (ENG_NAME)
  • VARCHAR2(1000) (GROUPS)
  • VARCHAR2(1000) (MANAGEMENT)
  • VARCHAR2(1000) (COUNTRY)
  • VARCHAR2(1000) (IMG)

ANIMAL_ALIEN_HARM (Untitled17)

  • VARCHAR2(1000) (KOR_NAME)
  • VARCHAR2(1000) (ENG_NAME)
  • VARCHAR2(1000) (GROUPS)
  • VARCHAR2(1000) (MANAGEMENT)
  • VARCHAR2(1000) (IMG)

ANIMAL_ENDANGERED_CSV (Untitled13)

  • VARCHAR2(1000) (GROUPS)
  • VARCHAR2(1000) (GRADE)
  • VARCHAR2(1000) (KOR_NAME)
  • VARCHAR2(1000) (ENG_NAME)
  • VARCHAR2(1000) (KOR_RED_LIST)
  • VARCHAR2(1000) (ENG_RED_LIST)

ANIMAL_ENDANGERED_IMG (Untitled14)

  • VARCHAR2(1000) (KOR_NAME)
  • VARCHAR2(1000) (IMG)

ANIMAL_ENDANGERED_JOIN (Untitled15)

  • VARCHAR2(1000) (GROUPS)
  • VARCHAR2(1000) (GRADE)
  • VARCHAR2(1000) (KOR_NAME)
  • VARCHAR2(1000) (ENG_NAME)
  • VARCHAR2(1000) (KOR_RED_LIST)
  • VARCHAR2(1000) (ENG_RED_LIST)
  • VARCHAR2(1000) (IMG)

ANIMAL_SHELTER (Untitled12)

  • VARCHAR2(1000) (AREA)
  • VARCHAR2(1000) (CENTERNAME)
  • VARCHAR2100) (PHONENUMBER)
  • VARCHAR2(1000) (CENTERADDR)

AREA_AIR (Untitled11)

  • NUMBER (REPYEAR)
  • VARCHAR2(100) (AREA)
  • NUMBER (AMOUNT)

AREA_TRASH (Untitled9)

  • NUMBER (REPYEAR)
  • VARCHAR2(100) (AREA)
  • NUMBER (AMOUNT)

AREA_WATER (Untitled10)

  • NUMBER (REPYEAR)
  • VARCHAR2(100) (AREA)
  • NUMBER (AMOUNT)

CONTESTBOARD (Untitled19)

  • NUMBER (CONLISTNO) — PK — Primary key — NOT NULL
  • NUMBER (USERNUM) — FK — Foreign key → MEMBER.NUMBER — NOT NULL
  • NUMBER (BOARDNO)
  • NUMBER (GROUPNO)
  • NUMBER (GROUPSQ)
  • NUMBER (REPLYNO)
  • NUMBER (LIKERATE)
  • NUMBER (LIKECNT)
  • VARCHAR2(2000) (WRITER)
  • VARCHAR2(3000) (TITLE)
  • CLOB (REPPIC)
  • CLOB (CONTENT)
  • DATE (REGDATE)

CONTESTLIST (Untitled18)

  • NUMBER (BOARDNO) — Primary key — NOT NULL
  • NUMBER (CONLISTNO) — Foreign key → CONTESTBOARD.NUMBER — NOT NULL
  • NUMBER (USERNUM) — PK — Foreign key → CONTESTBOARD.NUMBER — NOT NULL
  • VARCHAR2(100) (TITLE)
  • CLOB (REPPIC)
  • CLOB (CONTENT)
  • VARCHAR2(100) (FORWHO)
  • VARCHAR2(100) (PRIZE)
  • DATE (STARTDATE)
  • DATE (ENDDATE)
  • NUMBER (PARTNUM)
  • VARCHAR2(100) (SORT)
  • DATE (REGDATE)

FREEBOARD (Untitled4)

  • NUMBER (FREE_SEQ) — PK — Primary key — NOT NULL
  • VARCHAR2(1000) (ID)
  • VARCHAR2(2000) (TITLE)
  • VARCHAR2(4000) (CONTENT)
  • DATE (FREE_DATE)
  • NUMBER (USERNUM) — FK — Foreign key → MEMBER.NUMBER — NOT NULL

FREECOMMENT (Untitled5)

  • NUMBER (FREE_SEQ) — FK — Foreign key → FREEBOARD.NUMBER — NOT NULL
  • NUMBER (COMM_SEQ)
  • NUMBER (COMM_FREESEQ)
  • VARCHAR2(1000) (COMM_ID)
  • VARCHAR2(4000) (COMM_CONTENT)
  • DATE (COMM_DATE)

FUNDING (Untitled7)

  • VARCHAR2(2000) (FUNTITLE) — PK — Primary key — NOT NULL
  • NUMBER (USERNUM) — FK — Foreign key → MEMBER.NUMBER — NOT NULL
  • NUMBER (FUN_SEQ)
  • VARCHAR2(500) (FUN_ID)
  • NUMBER (GOALMONEY)
  • NUMBER (NOWMONEY)
  • DATE (FUNDATE)
  • NUMBER (PARTICIPANTS)
  • VARCHAR2(4000) (FUN_CONTENT)
  • VARCHAR2(2) (NOTICE)

FUNDINGPAY (Untitled6)

  • VARCHAR2(2000) (FUNTITLE) — FK — Foreign key → FUNDING.VARCHAR2(2000) — NOT NULL
  • NUMBER (USERNUM) — FK — Foreign key → FUNDING.NUMBER — NOT NULL
  • VARCHAR2(500) (FUNID)
  • NUMBER (FUNPAY)

MEMBER (Untitled)

  • NUMBER (USERNUM) — PK — Primary key — NOT NULL
  • VARCHAR2(100) (NAME)
  • VARCHAR2(100) (ID)
  • VARCHAR2(100) (PW)
  • NUMBER (PHONE)
  • VARCHAR2(100) (EMAIL)
  • VARCHAR2(100) (ADDR)
  • VARCHAR2(100) (ZONECODE)
  • INTEGER (ENABLED)
  • VARCHAR2(100) (ROLE)
  • DATE (JOINDATE)

STAR_RECORD (Untitled20)

  • NUMBER (CONLISTNO) — FK — Foreign key → CONTESTBOARD.NUMBER — NOT NULL
  • NUMBER (USERNUM2) — FK — Foreign key → CONTESTBOARD.NUMBER — NOT NULL
  • NUMBER (USERNUM)
  • NUMBER (BOARDNO)
  • NUMBER (STARRATE)

TRASH (Untitled8)

  • VARCHAR2(1000) (IMGREF)
  • VARCHAR2(1000) (TRASHNAME)
  • VARCHAR2(1000) (TRASHLIFE)

VOLCALENDAR (Untitled2)

  • NUMBER (CALNUM) — PK — Primary key — NOT NULL
  • VARCHAR2(2000) (CALTITLE)
  • VARCHAR2(500) (CALID)
  • DATE (CALRECDATE)
  • DATE (CALRECDATEEND)
  • DATE (CALVOLUNDATE)
  • DATE (CALVOLUNDATEEND)
  • VARCHAR2(4000) (CALCONTENT)
  • NUMBER (CALRECPEO)
  • NUMBER (CALNOWPEO)
  • VARCHAR2(2) (NOTICE)
  • VARCHAR2(2) (CALDEL)
  • NUMBER (USERNUM) — FK — Foreign key → MEMBER.NUMBER — NOT NULL

VOLMEMBER (Untitled3)

  • NUMBER (CALNUM) — FK — Foreign key → VOLCALENDAR.NUMBER — NOT NULL
  • VARCHAR2(2000) (VOLTITLE)
  • VARCHAR2(500) (VOLID)