샤시데브
테이블 (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