odiga
odigaTable
Tables (8)
imagebannerboard
- seq — NUMBER — Primary key — NOT NULL
- imageId — VARCHAR2(20) — NOT NULL
- imageName — VARCHAR2(40) — NOT NULL
- imagePrice — NUMBER — NOT NULL
- imageQty — NUMBER — NOT NULL
- imageContent — VARCHAR2(4000) — NOT NULL
- image1 — varchar2(200)
- logtime — DATE
mainbannerboard
- seq — NUMBER — Foreign key → imagebannerboard.seq — NOT NULL — imagebannerboard의 seq값과 동일
odigaMember
- id — varchar2(30) — Primary key
- name — varchar2(30) — NOT NULL
- pwd — varchar2(30) — NOT NULL
- gender — varchar2(3)
- email1 — varchar2(20)
- email2 — varchar2(20)
- tel1 — varchar2(10)
- tel2 — varchar2(10)
- tel3 — varchar2(10)
- zipcode — varchar2(10)
- addr1 — varchar2(100)
- addr2 — varchar2(100)
- report_count — NUMBER
- blocked — CHAR(1)
- logtime — date
odigaQnA
- seq — number — Primary key
- qnaId — varchar2(100) — NOT NULL
- qnaCheck — varchar2(1) — NOT NULL
- qnaUserContent — VARCHAR2(4000) — NOT NULL
- qnaAdminContent — VARCHAR2(4000)
- logtime — date
odigaTour
- seq — NUMBER — Primary key — NOT NULL
- tourId — VARCHAR2(50) — NOT NULL
- tourSubject — VARCHAR2(100)
- description — CLOB
- price — VARCHAR2(20)
- tourImage — VARCHAR2(255)
- logtime — DATE
odigafoodreview
- reviewid — VARCHAR2(20) — Primary key — NOT NULL
- seq — NUMBER — NOT NULL
- reviewname — VARCHAR2(40) — NOT NULL
- subject — VARCHAR2(255) — NOT NULL
- content — VARCHAR2(4000) — NOT NULL
- ref — NUMBER — NOT NULL
- step — NUMBER — NOT NULL
- grade — NUMBER
- likes — NUMBER
- hit — NUMBER
- image1 — varchar2(200)
- logtime — DATE
- replycount — NUMBER
odigareplyreply
- seq — number — Primary key — NOT NULL
- seq (seq2) — number — Foreign key → odigareviewreply.seq — NOT NULL
- reviewid — VARCHAR2(20) — Foreign key → odigareviewreply.reviewid — NOT NULL
- replyreplyid — VARCHAR2(20) — NOT NULL
- replyreplycontent — VARCHAR2(4000) — NOT NULL
- ref — NUMBER — NOT NULL
- step — NUMBER — NOT NULL
- logtime — DATE
- refref — NUMBER — NOT NULL
odigareviewreply
- seq — number — Primary key — NOT NULL
- reviewid — VARCHAR2(20) — Foreign key → odigafoodreview.reviewid — NOT NULL
- replyid — VARCHAR2(20) — NOT NULL
- replycontent — VARCHAR2(4000) — NOT NULL
- ref — NUMBER — NOT NULL
- step — NUMBER — NOT NULL
- likes — NUMBER
- logtime — DATE — NOT NULL