wowflee
Tables (16)
ADMIN (관리자계정)
- ADMINID — VARCHAR2(20) — Primary key — NOT NULL
- ADMINPW — VARCHAR2(20)
BOARD (게시글)
- BOARDNUM — NUMBER — Primary key — NOT NULL
- ID — VARCHAR2(20) — Foreign key → MEMBERINFO.ID — NOT NULL
- TITLE — VARCHAR2(100)
- IMAGE — VARCHAR2(500)
- INDATE — DATE
- MEMBERTYPE — VARCHAR2(20)
- KEYWORD — VARCHAR2(100)
- COMMENTS — VARCHAR2(2000)
- PRECAUTION — VARCHAR2(1000)
- NAME — VARCHAR2(100)
- TYPE — VARCHAR2(100)
- CONTRACTPERIOD — VARCHAR2(100)
- PRICE — NUMBER
- STOCK — NUMBER
- OPTIME — VARCHAR2(50)
- OFFDAY
- SCALE — NUMBER
- SPACEADDR1 — VARCHAR2(100)
- SPACEADDR2 — VARCHAR2(100)
- LATITUDE — NUMBER
- LONGITUDE — NUMBER
- RECOMMEND — CHAR(1)
- CURRENTS — CHAR(1)
- COUNT — NUMBER
- ZZIMCOUNT — NUMBER
- QNACOUNT — NUMBER
BOARD_QNA (Q&A)
- QNANUM — NUMBER — Primary key — NOT NULL
- BOARDNUM — NUMBER — Foreign key → BOARD.BOARDNUM — NOT NULL
- ID — VARCHAR2(20) — Foreign key → BOARD.ID — NOT NULL
- NICKNAME — VARCHAR2(50)
- COMMENTS — VARCHAR2(1000)
- REPLY — VARCHAR2(1000)
- INDATE — DATE
- REPLYDATE — DATE
COMMENTS (이용후기)
- COMMENTNUM — NUMBER — Primary key — NOT NULL
- ID — VARCHAR2(20) — Foreign key → MEMBERINFO.ID — NOT NULL
- COMMENTS — VARCHAR2(1000)
- MEMBERTYPE — VARCHAAR2(20)
- TYPE1 — VARCHAR2(10)
- TYPE2 — VARCHAR2(10)
- TYPE3 — VARCHAR2(10)
- TITLE — VARCHAR2(50)
- SCORE — NUMBER
- INDATE — DATE
CONTRACTHANASI (계약후대화방)
- HANASINUM — NUMBER — Primary key — NOT NULL
- CONTRACTNUM — NUMBER — Foreign key → CONTRACTINFO.CONTRACTNUM — NOT NULL
- SENDID — VARCHAR2(20)
- RECEIVEID — VARCHAR2(20)
- SENDNICKNAME — VARCHAR2(50)
- RECEIVENICKNAME — VARCHAR2(50)
- MESSAGE — VARCHAR2(1000)
- INDATE — DATE
CONTRACTINFO (계약상세정보)
- CONTRACTNUM — NUMBER — Primary key — NOT NULL
- SELLERID — VARCHAR2(20)
- SPACERID — VARCHAR2(20)
- STATE — CHAR(1)
- STOCKCOUNT — NUMBER
- SOLDCOUNT — NUMBER
- ORDERCOUNT — NUMBER
- SALES — NUMBER
- STARTDATE — DATE
- ENDDATE — DATE
- CONTRACTPERIOD — VARCHAR2(100)
- SPACEADDR1 — VARCHAR2(100)
- SPACEADDR2 — VARCHAR2(100)
- LATITUDE — NUMBER
- LONGITUDE — NUMBER
- SPACETYPE — VARCHAR2(100)
- SELLERTYPE — VARCHAR2(100)
CONTRACT_REQUEST (계약요청)
- REQUESTNUM — NUMBER — Primary key — NOT NULL
- ID — VARCHAR2(20) — Foreign key → MEMBERINFO.ID — NOT NULL
- NICKNAME — VARCHAR2(50)
- BOARDNUM — NUMBER
- PROPOSALNUM — NUMBER
- CONTRACTPERIOD — VARCHAR2(100)
- APPROVAL — CHAR(1)
- REQUESTDATE — DATE
- CHECKDATE — DATE
MEMBERINFO (회원정보)
- ID — VARCHAR2(20) — Primary key — NOT NULL
- PW — VARCHAR2(20)
- NAME — VARCHAR2(20)
- NICKNAME — VARCHAR2(50)
- PHONE — VARCHAR2(20)
- EMAIL — VARCHAR2(30)
- BIRTHDATE — DATE
- GENDER — VARCHAR2(5)
- ADDRESS1 — VARCHAR2(100)
- ADDRESS2 — VARCHAR2(100)
- MEMBERTYPE — VARCHAR2(20)
NOTICE (알림)
- NOTICENUM — NUMBER — Primary key — NOT NULL
- ID — VARCHAR2(20) — Foreign key → MEMBERINFO.ID — NOT NULL
- RECEIVEID — VARCHAR2(20)
- MESSAGE — VARCHAR2(1000)
- INDATE — DATE
- CONFIRM — CHAR(1)
- GO — VARCHAR2(100)
POINT (포인트)
- POINTNUM — NUMBER — Primary key — NOT NULL
- ID — VARCHAR2(20) — Foreign key → MEMBERINFO.ID — NOT NULL
- CURPOINT — NUMBER
- UDTDATE — DATE
- UDTADD (UPTADD) — BOOLEAN
- UDTPRICE — NUMBER
- UDTCONTENT — VARCHAR2(200)
PRODUCTINFO (제품정보)
- PRODUCTNUM — NUMBER — Primary key — NOT NULL
- SELLERNUM — NUMBER — Foreign key → SELLERINFO.SELLERNUM — NOT NULL
- PRODUCTNAME — VARCHAR2(100)
- PROD_TYPE — VARCHAR2(100) — NOT NULL
- KEYWORD — VARCHAR2(100)
PROPOSAL (제안서)
- PROPOSALNUM — NUMBER — Primary key — NOT NULL
- ID — VARCHAR2(20) — Foreign key → MEMBERINFO.ID — NOT NULL
- TITLE — VARCHAR2(100)
- IMAGE — VARCHAR2(500)
- INDATE — DATE
- MEMBERTYPE — VARCHAR2(20)
- KEYWORD — VARCHAR2(100)
- COMMENTS — VARCHAR2(2000)
- PRECAUTION — VARCHAR2(1000)
- NAME — VARCHAR2(100)
- TYPE — VARCHAR2(100)
- CONTRACTPERIOD — VARCHAR2(100)
- PRICE — NUMBER
- STOCK — NUMBER
- OPTIME — VARCHAR2(50)
- OFFDAY
- SCALE — NUMBER
- SPACEADDR1 — VARCHAR2(100)
- SPACEADDR2 — VARCHAR2(100)
- LATITUDE — NUMBER
- LONGITUDE — NUMBER
- RECOMMEND — CHAR(1)
RESERVATION (예약)
- RESERVNUM — NUMBER — Primary key — NOT NULL
- ID — VARCHAR2(20) — Foreign key → MEMBERINFO.ID — NOT NULL
- PRODUCTNUM — NUMBER — Foreign key → PRODUCTINFO.PRODUCTNUM — NOT NULL
- RESERVDATE — DATE
- KEYWORD — VARCHAR2
SELLERINFO (셀러정보)
- SELLERNUM — NUMBER — Primary key — NOT NULL
- ID — VARCHAR2(20) — Foreign key → MEMBERINFO.ID — NOT NULL
- SELLERNAME — VARCHAR2(100)
- TEL — VARCHAR2(20)
- COMMENTS — VARCHAR2(1000)
SPACEINFO (공간정보)
- SPACENUM — NUMBER — Primary key — NOT NULL
- ID — VARCHAR2(20) — Foreign key → MEMBERINFO.ID — NOT NULL
- SPACENAME — VARCHAR2(100)
- SPACE_TYPE — VARCHAR2(100)
- KEYWORD — VARCHAR2(100)
- TEL — VARCHAR2(20)
- COMMENTS — VARCHAR2(1000)
- SPACEADDR1 — VARCHAR2(100)
- SPACEADDR2 — VARCHAR2(100)
- LATITUDE — NUMBER
- LONGITUDE — NUMBER
ZZIMLIST (찜목록)
- ZZIMNO — NUMBER — Primary key — NOT NULL
- ID — VARCHAR2(20) — Foreign key → MEMBERINFO.ID — NOT NULL
- BOARDNUM — NUMBER
- ZZIMDATE — DATE