erd
Tables (6)
AUTH_ADMIN (권한테이블)
- AUTH_ID (Key) — Primary key — NOT NULL
- AUTH_NAME (Field)
- AUTH_DSC (Field2)
- AUTH_MAIL (Field3)
- AUTH_POST (Field4)
- AUTH_COM (Field5)
- AUTH_UPDATE_DATE (Field6)
CAL_POST (Calculation POST)
- CAL_POST_ID (Key4) — VARCHAR — Primary key — NOT NULL
- USER_ID (Key3) — VARCHAR — Foreign key → USER.USER_ID — NOT NULL
- CAL_TYPE_JOIN_ID (Key) — VARCHAR — Foreign key → CAL_TYPE_JOIN.CAL_TYPE_JOIN_ID — NOT NULL
- CAL_POST_DATE (Field2)
- CAL_POST_TITLE (Field3)
- CAL_POST_CONTENTS (Field4) — TEXT
- CAL_POST_FILE (Field5)
- Key2 — NOT NULL
CAL_TYPE (타입 테이블)
- CAL_TYPE_ID (Key) — VARCHAR — Primary key — NOT NULL
- CAL_TYPE_NAME (Field) — VARCHAR
- CAL_TYPE_DSC (Key3) — TEXT — NOT NULL
CAL_TYPE_JOIN (타입 조인테이블)
- CAL_TYPE_JOIN_ID (Key) — VARCHAR — Primary key — NOT NULL
- CAL_TYPE_ID (Key2) — VARCHAR — Foreign key → CAL_TYPE.CAL_TYPE_ID — NOT NULL
POST_LOG (유저별 포스트 로그)
- LOG_ID (Key) — Primary key — NOT NULL
- CAL_POST_ID (Key4) — VARCHAR — Foreign key → CAL_POST.CAL_POST_ID — NOT NULL
- USER_ID (Key3) — VARCHAR — Foreign key → CAL_POST.USER_ID — NOT NULL
- CAL_TYPE_JOIN_ID (Key2) — VARCHAR — Foreign key → CAL_POST.CAL_TYPE_JOIN_ID — NOT NULL
- LOG_DATE (Field5)
USER (회원 정보 테이블)
- USER_ID (Key) — VARCHAR — Primary key — NOT NULL
- AUTH_ID (Key2) — Foreign key → AUTH_ADMIN.AUTH_ID — NOT NULL
- USER_PW (Field) — VARCHAR
- USER_NAME (Field2) — VARCHAR
- USER_EMAIL (Field3) — VARCHAR
- USER_LAST_LOGIN (Field4) — TIMESTAMP