team_kdu

Tables (10)

THISEVENT (이벤트 내역 테이블)

  • EVENT_NO (Key) — NUMBER — Primary key — NOT NULL
  • EVENT_NAME (Field) — VARCHAR
  • EVENT_CONTENT (Field7) — VARCHAR
  • EVENT_STARTDATE (Field3) — DATE
  • EVENT_ENDDATE (Field4) — DATE
  • EVENT_FLAG (Field5) — CHAR(1)
  • EVENT_FILE_SRC (Field6) — VARCHAR
  • EVENT_WIN_DATE (Field8) — DATE
  • ITEM_CODE (Key2) — NUMBER — Foreign key → THISITEM.ITEM_CODE — NOT NULL

THISEVENTWIN (당첨자 리스트 테이블)

  • EVENT_NO (Key) — NUMBER — Foreign key → THISEVENT.EVENT_NO — NOT NULL
  • MEM_NO1 (Key2) — NUMBER — NOT NULL
  • MEM_NO2 (Field) — NUMBER
  • MEM_NO3 (Field2) — NUMBER

THISFAQ (FAQ (미리 준비된 질문/답) 테이블)

  • FAQ_QUES_NO (Field) — NUMBER
  • FAQ_QUES_NAME (Field2) — VARCHAR
  • FAQ_QUES_ANS (Field3) — VARCHAR
  • FAQ_QUES_TYPE_CODE (Key) — NUMBER — Foreign key → THISFAQTYPE.FAQ_QUES_TYPE_CODE — NOT NULL

THISFAQTYPE (FAQ 질문 유형 테이블)

  • FAQ_QUES_TYPE_CODE (Key) — NUMBER — Primary key — NOT NULL
  • FAQ_QUES_TYPE_NAME (Field) — VARCHAR

THISINQUIRY (사용자 문의 테이블)

  • INQUIRY_NO (Key) — NUMBER — Primary key — NOT NULL
  • MEM_NO (Key2) — NUMBER — Foreign key → TMSTMEMBER.MEM_NO — NOT NULL
  • INQUIRY_TYPE_CODE (Key3) — NUMBER — Foreign key → THISINQUIRYTYPE.INQUIRY_TYPE_CODE — NOT NULL
  • INQUIRY_TITLE (Field) — VARCHAR
  • INQUIRY_CONTENT (Field2) — VARCHAR
  • INQUIRY_FILE_SRC (Field3) — VARCHAR
  • Field4

THISINQUIRYTYPE (문의 유형 테이블)

  • INQUIRY_TYPE_CODE (Key) — NUMBER — Primary key — NOT NULL
  • INQUIRY_TYPE_NAME (Field) — VARCHAR

THISITEM (경품 내역 테이블)

  • ITEM_CODE (Key) — NUMBER — Primary key — NOT NULL
  • ITEM_NAME (Field) — VARCHAR
  • ITEM_SUPPLY (Field2) — NUMBER
  • ITEM_STOCK (Field3) — NUMBER

THISREPORT (사용자 신고 테이블)

  • REPORT_NO (Key3) — NUMBER — Primary key — NOT NULL
  • MEM_NO (Key2) — NUMBER — Foreign key → TMSTMEMBER.MEM_NO — NOT NULL
  • REPORT_MEM_NO (Key) — NUMBER — NOT NULL
  • REPORT_TYPE_CODE (Key4) — NUMBER — Foreign key → THISREPORTTYPE.REPORT_TYPE_CODE — NOT NULL

THISREPORTTYPE (신고 사유 테이블)

  • REPORT_TYPE_CODE (Key) — NUMBER — Primary key — NOT NULL
  • REPORT_TYPE_NAME (Field) — VARCHAR

TMSTMEMBER (사용자 테이블)

  • MEM_NO (Key) — NUMBER — Primary key — NOT NULL
  • MEM_ID (Field) — VARCHAR
  • MEM_PW (Field2) — VARCHAR
  • MEM_NAME (Field3) — VARCHAR
  • MEM_PHONE (Field4) — VARCHAR
  • MEM_EMAIL (Field5) — VARCHAR
  • MEM_ADDRESS (Field6) — VARCHAR
  • MEM_GENDER (Field7) — VARCHAR
  • MEM_BIRTH (Field8) — DATE
  • MEM_MARKETING (Field9) — CHAR(1)
  • MEM_AREA1 (Field10) — VARCHAR
  • MEM_AREA2 (Field11) — VARCHAR
  • MEM_AREA3 (Field12) — VARCHAR
  • MEM_THEME1 (Field13) — VARCHAR
  • MEM_THEME2 (Field14) — VARCHAR
  • MEM_THEME3 (Field15) — VARCHAR
  • MEM_THEME4 (Field16) — VARCHAR
  • MEM_THEME5 (Field17) — VARCHAR