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