불꽃축제

테이블 (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