국삐ERD

테이블 (12)

AFTER

  • AF_IDX — VARCHAR2(200) — 기본 키 — NOT NULL
  • TR_ID — VARCHAR2(200)
  • U_MEM_ID — VARCHAR2(200)
  • STAT — NUMBER(2,0)
  • CONTENT — VARCHAR2(4000)

API

  • A_IDX — VARCHAR2(200) — 기본 키 — NOT NULL
  • TR_ID — VARCHAR2(200)
  • U_MEM_ID — VARCHAR2(200)
  • U_NAME — VARCHAR2(100)
  • U_BIRTH — VARCHAR2(100)
  • U_EMAIL — VARCHAR2(200)
  • U_PHONE — VARCHAR2(100)
  • U_ADDR — VARCHAR2(200)
  • STAT — NUMBER(2,0)

AT_TR

  • AT_IDX — VARCHAR2(200) — 기본 키 — NOT NULL
  • TRANING_ID — VARCHAR2(400) — 외래 키 → TRANING.TRANING_ID
  • TR_ID — VARCHAR2(400)
  • SRCHTRPRID — VARCHAR2(4000)
  • SRCHTRPRDEGR — NUMBER
  • HIT — NUMBER
  • ADDR — VARCHAR2(4000)
  • TITLE — VARCHAR2(4000)
  • SUBJECT — VARCHAR2(4000)
  • START_DATE — DATE
  • END_DATE — DATE

BBS_T

  • B_IDX — NUMBER(6,0) — 기본 키
  • SUBJECT — VARCHAR2(50)
  • WRITER — VARCHAR2(20)
  • CONTENT — CLOB
  • FILE_NAME — VARCHAR2(50)
  • ORI_NAME — VARCHAR2(50)
  • PWD — VARCHAR2(20)
  • WRITE_DATE — DATE
  • IP — VARCHAR2(30)
  • HIT — NUMBER(4,0)
  • STATUS — NUMBER(1,0)
  • BNAME — VARCHAR2(100)
  • ID — VARCHAR2(4000)

COMMENT_T

  • B_IDX (B_IDX2) — NUMBER(6,0) — 외래 키 → BBS_T.B_IDX
  • C_IDX — NUMBER(6,0)
  • WRITER — VARCHAR2(20)
  • CONTENT — CLOB
  • PWD — VARCHAR2(20)
  • WRITE_DATE — DATE
  • IP — VARCHAR2(30)

ENROLMENT

  • E_COMPANY — VARCHAR2(100)
  • E_TRNAME — VARCHAR2(300)
  • E_TRID — VARCHAR2(50)
  • E_EMAIL — VARCHAR2(200)
  • E_UID — VARCHAR2(20)
  • E_UNAME — VARCHAR2(50)
  • E_UGEN — VARCHAR2(10)
  • E_UPHONE — VARCHAR2(20)
  • E_UBDAY — VARCHAR2(50)

HELP_BBS

  • H_IDX — VARCHAR2(200) — 기본 키 — NOT NULL
  • TR_ID — VARCHAR2(200)
  • U_MEM_ID — VARCHAR2(200)
  • STAT — NUMBER(2,0)
  • CONTENT — VARCHAR2(4000)

INBODY

  • KG — VARCHAR2(2000)
  • CM — VARCHAR2(2000)
  • PROTINE — VARCHAR2(2000)
  • FAT — VARCHAR2(4000) — NOT NULL

LIKE_T

  • L_IDX — VARCHAR2(200) — 기본 키 — NOT NULL
  • U_MEM_ID — VARCHAR2(200)
  • TR_ID — VARCHAR2(200)
  • TR_NAME — VARCHAR2(100)
  • TR_TERM — VARCHAR2(100)
  • LIKE_DATE — VARCHAR2(200)
  • STAT — NUMBER(2,0)

RD

  • R_RANK — NUMBER(2,0) — NOT NULL
  • SRCHTRPRID — VARCHAR2(4000) — NOT NULL
  • SRCHTRPRDEGR — VARCHAR2(4000) — NOT NULL
  • SUBJECT — VARCHAR2(4000)
  • TITLE — VARCHAR2(4000)
  • ADDR — VARCHAR2(4000)
  • STATE — NUMBER
  • START_DATE — DATE
  • END_DATE — DATE

TRANING

  • TRANING_ID — VARCHAR2(400) — 기본 키
  • CONTENT — VARCHAR2(4000)
  • PRICE — NUMBER
  • PERSONNEL — NUMBER
  • TERM — DATE
  • MANAGER — VARCHAR2(400)
  • STAT — NUMBER

U_MEMBER

  • ID — VARCHAR2(100) — 기본 키 — NOT NULL
  • PW — VARCHAR2(100)
  • NAME — VARCHAR2(100)
  • BIRTH — VARCHAR2(100)
  • EMAIL — VARCHAR2(200)
  • PHONE — VARCHAR2(100)
  • ADDR — VARCHAR2(200)
  • MEMBER — VARCHAR2(200)
  • STAT — VARCHAR2(200)
  • U_DATE — DATE
  • C_NUM — VARCHAR2(4000)
  • C_NAME — VARCHAR2(4000)
  • ADDR2 — VARCHAR2(4000)