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