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