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