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