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