국삐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)