Datecock

Tables (14)

BIZ_QNA_BOARD

  • BNO — NUMBER
  • TITLE — VARCHAR2(200) — NOT NULL
  • CONTENT — CLOB — NOT NULL
  • WRITER — VARCHAR2(50) — NOT NULL
  • REGDATE — DATE — NOT NULL
  • VIEWCNT — NUMBER — NOT NULL
  • ANSWER_STATUS — VARCHAR2(20) — NOT NULL
  • ANSWER_CONTENT — CLOB
  • ANSWER_WRITER — VARCHAR2(50)
  • ANSWER_DATE — DATE
  • IMAGE_FILE — VARCHAR2(255)
  • SECRET — NUMBER(1) — NOT NULL

BOARD

  • BNO — NUMBER
  • TITLE — VARCHAR2(200) — NOT NULL
  • CONTENT — CLOB — NOT NULL
  • WRITER — VARCHAR2(50) — NOT NULL
  • REGDATE — TIMESTAMP
  • VIEWCNT — NUMBER
  • REPLYCNT — NUMBER — NOT NULL
  • LIKECNT — NUMBER
  • THUMBNAIL — VARCHAR2(300)

DATECOCKQNA

  • qnanum — NUMBER
  • title — VARCHAR2(300)
  • content — VARCHAR2(2000)
  • writer — VARCHAR2(100)
  • type — VARCHAR2(20)
  • email — VARCHAR2(300)
  • phone — VARCHAR2(30)
  • notify_type — VARCHAR2(20)
  • answer — VARCHAR2(2000)
  • regdate — DATE

DateCockBusinessInput

  • businessnumber — VARCHAR2(70) — Primary key — NOT NULL
  • businessname — VARCHAR2(100)
  • address — VARCHAR2(130)
  • businesstime — VARCHAR2(80)
  • phone — VARCHAR2(100)
  • image — VARCHAR2(250)
  • information — VARCHAR2(3000)
  • age — NUMBER(7)
  • zone — VARCHAR2(100)
  • activity — VARCHAR2(40)

DateCockBusinessLogin

  • businessnumber — VARCHAR2(70) — Primary key — NOT NULL
  • password — VARCHAR2(100)

DateCockBusinessMember

  • businessnumber — VARCHAR2(70) — Primary key — NOT NULL
  • password — VARCHAR2(100)
  • email — VARCHAR2(100)
  • businessname — VARCHAR2(40)
  • phone — VARCHAR2(100)
  • birthyear — VARCHAR2(100)

DateCockChoice

  • age — NUMBER(5)
  • address — VARCHAR2(40)
  • activity — VARCHAR2(15)

DateCockCondition

  • conditionAge — VARCHAR2(50)
  • conditionZone — VARCHAR2(150)
  • conditionActivity — VARCHAR2(50)

DateCockGuest

  • name — VARCHAR2(30)
  • memo — VARCHAR2(500)
  • todays — DATE

DateCockLogin

  • id — VARCHAR2(70) — Primary key — NOT NULL
  • password — VARCHAR2(100)

DateCockMember

  • id — VARCHAR2(70) — Primary key — NOT NULL
  • password — VARCHAR2(100)
  • email — VARCHAR2(100)
  • name — VARCHAR2(30)
  • birth — VARCHAR2(100)
  • phone — VARCHAR2(100)
  • admin — NUMBER(1) — NOT NULL

DateCockReservation

  • reservation_id — NUMBER
  • name — VARCHAR2(40)
  • phone — VARCHAR2(100)
  • day — DATE
  • intime — VARCHAR2(60)
  • businessname — VARCHAR2(100)
  • id — VARCHAR2(70) — NOT NULL
  • image — VARCHAR2(1500)

REPLY

  • RNO — NUMBER
  • BNO — NUMBER — NOT NULL
  • REPLYTEXT — VARCHAR2(1000) — NOT NULL
  • REPLYER — VARCHAR2(50) — NOT NULL
  • REPLYDATE — TIMESTAMP
  • UPDATEDATE — TIMESTAMP

USER_QNA_BOARD

  • BNO — NUMBER
  • TITLE — VARCHAR2(200) — NOT NULL
  • CONTENT — CLOB — NOT NULL
  • WRITER — VARCHAR2(50) — NOT NULL
  • REGDATE — DATE — NOT NULL
  • VIEWCNT — NUMBER — NOT NULL
  • ANSWER_STATUS — VARCHAR2(20) — NOT NULL
  • ANSWER_CONTENT — CLOB
  • ANSWER_WRITER — VARCHAR2(50)
  • ANSWER_DATE — DATE
  • IMAGE_FILE — VARCHAR2(255)
  • SECRET — NUMBER(1) — NOT NULL