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)