샤시데브

테이블 (16)

SD_BLACK

  • id — NUMBER — 기본 키 — NOT NULL
  • ip — VARCHAR2(30) — NOT NULL
  • use_flag — VARCHAR2(1) — NOT NULL

SD_CATEGORYS

  • id — NUMBER — 기본 키 — NOT NULL
  • seq — NUMBER — NOT NULL
  • use_flag — VARCHAR2(1) — NOT NULL
  • del_flag — NOT NULL
  • created_date — DATE — NOT NULL
  • updated_date — DATE
  • parent — NUMBER — 외래 키 → SD_CATEGORYS.id — NOT NULL
  • user_id — NUMBER — 외래 키 → SD_USERS.id — NOT NULL

SD_COMMENTS

  • id — NUMBER — 기본 키 — NOT NULL
  • content — VARCHAR2(300) — NOT NULL
  • del_flag — VARCHAR2(1) — NOT NULL
  • created_date — DATE — NOT NULL
  • updated_date — DATE
  • user_id — NUMBER — 외래 키 → SD_USERS.id — NOT NULL
  • title_id — NUMBER — 외래 키 → SD_TITLES.id — NOT NULL

SD_CONFIRM

  • id — NUMBER — 기본 키 — NOT NULL
  • key — VARCHAR2(255) — NOT NULL
  • email — VARCHAR2(100) — NOT NULL
  • created_date — DATE — NOT NULL
  • success_date — DATE
  • user_id — NUMBER — 외래 키 → SD_USERS.id — NOT NULL

SD_CONTENTS

  • id — NUMBER — 기본 키 — NOT NULL
  • type — VARCHAR2(1)
  • content — CLOB
  • seq — NUMBER
  • title_id — NUMBER — 외래 키 → SD_TITLES.id — NOT NULL

SD_FILTER

  • id — 기본 키 — NOT NULL
  • text — VARCHAR2(10) — NOT NULL
  • created_date — DATE — NOT NULL
  • updated_date — DATE
  • del_flag — VARCHAR2(1) — NOT NULL

SD_LANGS

  • id — VARCHAR2(2) — 기본 키 — NOT NULL
  • name — VARCHAR2(10) — NOT NULL
  • use_flag — VARCHAR2(1) — NOT NULL

SD_LOGS

  • id — NUMBER — 기본 키 — NOT NULL
  • type — VARCHAR2(10) — NOT NULL
  • table — VARCHAR2(30) — NOT NULL
  • target — NUMBER — NOT NULL
  • ip — VARCHAR2(30) — NOT NULL
  • created_date — DATE — NOT NULL

SD_OAUTH

  • id — NUMBER — 기본 키 — NOT NULL
  • token — VARCHAR2(255) — NOT NULL
  • provider — VARCHAR2(30) — NOT NULL
  • user_id — NUMBER — 외래 키 → SD_USERS.id — NOT NULL

SD_PROFILES

  • id — NUMBER — 기본 키 — NOT NULL
  • nickname — VARCHAR2(30 — NOT NULL
  • email — VARCHAR2(100) — NOT NULL
  • name — VARCHAR2(100) — NOT NULL
  • homepage — VARCHAR2(100)
  • address — VARCHAR2(100)
  • created_date — DATE — NOT NULL
  • user_id — NUMBER — 외래 키 → SD_USERS.id — NOT NULL

SD_TAGS

  • id — NUMBER — 기본 키 — NOT NULL
  • name — VARCHAR2(30) — NOT NULL
  • del_flag — VARCHAr2(1) — NOT NULL
  • created_date — DATE — NOT NULL
  • updated_date — DATE
  • user_id — NUMBER — 외래 키 → SD_USERS.id — NOT NULL

SD_TEMPLATE

  • id — NUMBER — 기본 키 — NOT NULL
  • con tent — CLOB — NOT NULL
  • del_flag — VARCHAR2(1) — NOT NULL
  • created_date — DATE — NOT NULL
  • updated_date — DATE
  • user_id — NUMBER — 외래 키 → SD_USERS.id — NOT NULL
  • content_id — NUMBER — 외래 키 → SD_CONTENTS.id — NOT NULL

SD_TEXTS

  • id — VARCHAR2(100) — 기본 키 — NOT NULL
  • text — VARCHAR2(100) — NOT NULL
  • use_flag — VARCHAR2(1) — NOT NULL
  • del_flag — VARCHAR2(1) — NOT NULL
  • lang_id — VARCHAR2(2) — 외래 키 → SD_LANGS.id — NOT NULL

SD_TITLES

  • id — NUMBER — 기본 키 — NOT NULL
  • name — VARCHAR2(100) — NOT NULL
  • open_flag — VARCHAR2(1) — NOT NULL
  • temp_flag — VARCHAR2(1) — NOT NULL
  • del_flag — VARCHAR2(1) — NOT NULL
  • comment_flag — VARCHAR2(1) — NOT NULL
  • secret_comment_flag — VARCHAR2(1) — NOT NULL
  • search_flag — VARCHAR2(1) — NOT NULL
  • created_date — DATE — NOT NULL
  • updated_date — DATE
  • user_id — NUMBER — 외래 키 → SD_USERS.id — NOT NULL
  • category_id — NUMBER — 외래 키 → SD_CATEGORYS.id
  • tag_id — NUMBER — 외래 키 → SD_TAGS.id

SD_UI

  • id — NUMBER — 기본 키 — NOT NULL
  • postion — VARCHAR2(10) — NOT NULL
  • seq — NUMBER — NOT NULL
  • use_flag — VARCHAR2(1) — NOT NULL
  • type — VARCHAR2(10) — NOT NULL
  • content — VARCHAR2(400)
  • text_id — VARCHAR2(100) — 외래 키 → SD_TEXTS.id — NOT NULL

SD_USERS

  • id — NUMBER — 기본 키 — NOT NULL
  • login — VARCHAR2(30) — NOT NULL
  • pw — VARCHAR2(30) — NOT NULL
  • del_flag — VARCHAR2(1) — NOT NULL
  • grade — VARCHAR2(30) — NOT NULL
  • created_date — DATE — NOT NULL
  • lang_id — VARCHAR2(2) — 외래 키 → SD_LANGS.id