불꽃축제
테이블 (8)
TB_DATA
- DATA_INDEX — varchar2(30) — 기본 키 — NOT NULL
- DATA_THUMB — varchar2(3000) — NOT NULL
- DATA_IMG — varchar2(3000) — NOT NULL
- DATA_SIZE — NUMBER
- DATA_KATE — varchar2(1)
TB_EVENT
- EVENT_INDEX — varchar2(30) — 기본 키 — NOT NULL
- EVENT_TITLE — varchar2(3000) — NOT NULL
- EVENT_CONTENT — varchar2(4000) — NOT NULL
- EVENT_IMG — varchar2(3000)
- EVENT_THUMB — varchar2(3000)
- EVENT_SIZE — NUMBER
- EVENT_KATE — varchar2(1)
TB_EVENT_APPLY
- EVENT_APPLY_NUM — varchar2(30) — 기본 키
- EVENT_WIN — varchar2(9)
- EVENT_TITLE — varchar2(3000)
- USER_ID — varchar2(20) — 외래 키 → TB_MEMBER.USER_ID — NOT NULL
- EVENT_INDEX — varchar2(30) — 외래 키 → TB_EVENT.EVENT_INDEX — NOT NULL
TB_FOOD
- FOOD_INDEX — varchar2(30) — NOT NULL
- FOOD_CONTENT — varchar2(3000) — NOT NULL
- FOOD_THUMB — varchar2(3000) — NOT NULL
- FOOD_IMG — varchar2(3000) — NOT NULL
- FOOD_SIZE — NUMBER
- FOOD_KATE — varchar2(1)
TB_MAIN
- MAIN_INDEX — varchar2(30) — 기본 키 — NOT NULL
- MAIN_TITLE — varchar2(300) — NOT NULL
- MAIN_CONTENT — varchar2(3000)
- MAIN_IMG — varchar2(3000) — NOT NULL
- MAIN_FILE_SIZE — NUMBER
- MAIN_KATE — varchar2(1)
TB_MEMBER
- USER_ID — varchar2(20) — 기본 키 — NOT NULL
- USER_NIC — varchar2(30) — NOT NULL
- USER_PW — varchar2(30) — NOT NULL
- USER_ORIGINAL — varchar2(3000)
- USER_NEW_IMG — varchar2(3000)
- USER_FILE_SIZE — NUMBER
- USER_BLIND — varchar2(1)
- USER_EVENTAPPLY — varchar2(1)
- AMIN_TIM — varchar2(1)
- DEL_GB — varchar2(1)
TB_NOTICE
- NOTICE_INDEX — VARCHAR2(30) — 기본 키
- NOTICE_DATE — DATE
- NOTICE_TITLE — VARCHAR2(300) — NOT NULL
- NOTICE_CONTENT — VARCHAR2(3000)
- NOTICE_ORIGINAL — VARCHAR2(3000)
- NOTICE_NEW_IMG — VARCHAR2(3000)
- NOTICE_FILE_SIZE — NUMBER
- NOTICE_TIME — DATE
- NOTICE_KATE — VARCHAR2(1)
TB_REVIEW
- REVIEW_INDEX — VARCHAR2(30) — 기본 키
- REVIEW_DATE — DATE
- REVIEW_TITLE — VARCHAR2(300) — NOT NULL
- REVIEW_CONTENT — VARCHAR2(3000)
- DEL_GB — VARCHAR2(1)
- USER_ID — varchar2(20) — 외래 키 → TB_MEMBER.USER_ID — NOT NULL