fdgdfg
Tables (17)
TBRD
- BRD_NUM — NUMBER(10,0) — Primary key — NOT NULL
- BRD_TTL — VARCHAR2(40) — NOT NULL
- BRD_CN — VARCHAR2(4000) — NOT NULL
- BRD_PIC — VARCHAR2(1000)
- BRD_TOP — NUMBER(1,0) — NOT NULL
- BRD_REGDATE — DATE
- BRD_UPDDATE — DATE
- BRD_CATE — VARCHAR2(40) — NOT NULL
- GRP_NUM — NUMBER(10,0) — Foreign key → TGRP.GRP_NUM — NOT NULL
- USER_NUM — NUMBER(10,0) — Foreign key → TUSER.USER_NUM — NOT NULL
TBRD_FILE
- BRD_FILE_NUM — NUMBER(10,0) — Primary key — NOT NULL
- BRD_FILE_URL — VARCHAR2(1000) — NOT NULL
- BRD_NUM — NUMBER(10,0) — Foreign key → TBRD.BRD_NUM — NOT NULL
TBRD_PIC
- BRD_PIC — NUMBER(10,0)
- BRD_URL — VARCHAR2(1000) — NOT NULL
- BRD_NUM — NUMBER(10,0) — Foreign key → TBRD.BRD_NUM — NOT NULL
TCODE
- Field4 — VARCHAR2(20)
- Field5 — VARCHAR2(20)
- Field — NUMBER(2,0)
- Field2 — VARCHAR2(20)
- Field3 — NUMBER(2,0)
- Field6 — NUMBER(1,0)
TGRP
- GRP_NUM — NUMBER(10,0) — Primary key — NOT NULL
- GRP_NAME — VARCHAR2(100) — NOT NULL
- GRP_CAP — NUMBER(10,0) — NOT NULL
- GRP_INFO — VARCHAR2(500) — NOT NULL
- GRP_PIC — VARCHAR2(1000)
- GRP_REP — VARCHAR2(40) — NOT NULL
- GRP_REGDATE — DATE
- GRP_STATUS — NUMBER(1,0) — NOT NULL
- GRP_REGN_NUM — NUMBER(10,0) — Foreign key → TGRP_REGN.GRP_REGN_NUM — NOT NULL
- LANG_NUM1 — VARCHAR2(40) — Foreign key → TLANG.LANG_NUM — NOT NULL
- LANG_NUM2 — VARCHAR2(40) — Foreign key → TLANG.LANG_NUM
- LANG_NUM3 — VARCHAR2(40) — Foreign key → TLANG.LANG_NUM
TGRP_LIST
- USER_NUM — NUMBER(10,0) — Foreign key → TUSER.USER_NUM — NOT NULL
- GRP_NUM — NUMBER(10,0) — Foreign key → TGRP.GRP_NUM — NOT NULL
- GRP_ROLE — VARCHAR2(40) — NOT NULL
- GRP_BAN — VARCHAR2(40) — NOT NULL
TGRP_REGN
- GRP_REGN_NUM — NUMBER(10,0) — Primary key — NOT NULL
- GRP_REGN_SIDO — NUMBER(1,0) — NOT NULL
- GRP_REGN_SGG — NUMBER(1,0) — NOT NULL
TGRP_REPORT
- USER_NUM — NUMBER(10,0) — Foreign key → TUSER.USER_NUM — NOT NULL
- GRP_NUM — NUMBER(10,0) — Foreign key → TGRP.GRP_NUM — NOT NULL
- REPORT_RSN — NUMBER(1,0) — NOT NULL
TGRP_WISH
- GRP_WISH_NUM — NUMBER(10,0) — Primary key — NOT NULL
- USER_NUM — NUMBER(10,0) — Foreign key → TUSER.USER_NUM — NOT NULL
- GRP_NUM — NUMBER(10,0) — Foreign key → TGRP.GRP_NUM — NOT NULL
TLANG
- LANG_NUM — NUMBER(10,0) — Primary key — NOT NULL
- LANG_NAME — VARCHAR2(40) — NOT NULL
TRPL
- RPL_NUM — NUMBER(10,0) — Primary key — NOT NULL
- RPL_REGDATE — DATE
- RPL_UPDDATE — DATE
- RPL_PARENT_NUM — VARCHAR2(40) — Foreign key → TRPL.RPL_NUM
- BRD_NUM — NUMBER(10,0) — Foreign key → TBRD.BRD_NUM — NOT NULL
- USER_NUM — NUMBER(10,0) — Foreign key → TUSER.USER_NUM — NOT NULL
TSTD
- STD_NUM — NUMBER(10,0) — Primary key — NOT NULL
- STD_NAME — VARCHAR2(200) — NOT NULL
- STD_START_TIME — DATE — NOT NULL
- STD_END_TIME — DATE — NOT NULL
- STD_EXP — VARCHAR2(40)
- STD_CAP — NUMBER(3,0) — NOT NULL
- STD_INFO — VARCHAR2(500) — NOT NULL
- STD_REP — VARCHAR2(40) — NOT NULL
- STD_REGDATE — DATE
- STD_STATUS — NUMBER(1,0) — NOT NULL
- GRP_NUM — NUMBER(10,0) — Foreign key → TGRP.GRP_NUM — NOT NULL
- STD_PLC_NUM — NUMBER(10,0) — Foreign key → TSTD_PLC.STD_PLC_NUM — NOT NULL
TSTD_LIST
- STD_NUM — NUMBER(10,0) — Foreign key → TSTD.STD_NUM — NOT NULL
- USER_NUM — NUMBER(10,0) — Foreign key → TUSER.USER_NUM — NOT NULL
- GRP_USER_GRADE — NUMBER(1,0) — NOT NULL
TSTD_PLC
- STD_PLC_NUM — NUMBER(10,0) — Primary key — NOT NULL
- STD_PLC_LAT — VARCHAR2(40) — NOT NULL
- STD_PLC_LNG — VARCHAR2(40) — NOT NULL
- STD_PLC_PIC — VARCHAR2(1000)
- STD_PLC_NAME — VARCHAR2(100) — NOT NULL
- STD_PLC_ADDR — VARCHAR2(200) — NOT NULL
TSTD_WISH
- STD_WISH_NUM — NUMBER(10,0) — Primary key — NOT NULL
- STD_NUM — NUMBER(10,0) — Foreign key → TSTD.STD_NUM — NOT NULL
- USER_NUM — NUMBER(10,0) — Foreign key → TUSER.USER_NUM — NOT NULL
TUSER
- USER_NUM — NUMBER(10,0) — Primary key — NOT NULL
- USER_PWD — VARCHAR2(40) — NOT NULL
- USER_NAME — VARCHAR2(40) — NOT NULL
- USER_EMAIL — VARCHAR2(255) — NOT NULL
- USER_REGDATE — DATE
- USER-STATUS — NUMBER(1,0) — NOT NULL
- USER_PIC — VARCHAR(1000)
- USER_BRDY — DATE
- USER_TEL — VARCHAR(20)
- USER_PATH — VARCHAR2(40) — NOT NULL
TUSER_ALERT
- ALERT_NUM — NUMBER(10,0) — Primary key — NOT NULL
- USER_NUM — NUMBER(10,0) — Foreign key → TUSER.USER_NUM — NOT NULL
- ALERT_CN — VARCHAR2(255) — NOT NULL
- ALERT_DATE — DATE
- ALERT_STATUS — NUMBER(1,0) — NOT NULL