togym

Tables (10)

BANK_TB

  • BK_NO — NUMBER — Primary key — NOT NULL
  • BK_ACCOUNT — NVARCHAR2(20) — NOT NULL
  • BK_PWD — NVARCHAR2(20) — NOT NULL
  • BK_NAME — NVARCHAR2(20) — NOT NULL
  • BK_CHECK — NUMBER

BUY_TB

  • B_CODE — NVARCHAR2(20) — Primary key — NOT NULL
  • B_CATE — NVARCHAR2(10) — NOT NULL
  • B_SUBCATE — NVARCHAR2(10) — NOT NULL
  • B_TITLE — NVARCHAR2(50) — NOT NULL
  • B_TERM — NVARCHAR2(10) — NOT NULL
  • B_PRICE — NUMBER — NOT NULL

CART_TB

  • C_CODE — NVARCHAR2(20) — Primary key — NOT NULL
  • M_ID — NVARCHAR2(20) — NOT NULL
  • B_CODE — NVARCHAR2(20) — NOT NULL

MEMBER_TB

  • M_ID — NVARCHAR2(20) — Primary key — NOT NULL
  • M_PW — NVARCHAR2(100) — NOT NULL
  • M_NAME — NVARCHAR2(10) — NOT NULL
  • M_EMAIL — NVARCHAR2(50) — NOT NULL
  • M_PHONE — NVARCHAR2(11) — NOT NULL
  • M_BIRTH — NVARCHAR2(6) — NOT NULL
  • M_JOINDATE — DATE — NOT NULL
  • M_POINT — NUMBER — NOT NULL

PAY_TB

  • P_NO — NUMBER — Primary key — NOT NULL
  • C_CODE — NVARCHAR2(20) — NOT NULL
  • P_TOTAL — NUMBER — NOT NULL
  • P_DATE — DATE
  • P_PAYMENT — NVARCHAR2(20)

REVIEW_TB

  • R_NO — NUMBER — Primary key — NOT NULL
  • R_CATE — NVARCHAR2(10) — NOT NULL
  • R_TITLE — NVARCHAR2(20) — NOT NULL
  • R_CONTENTS — NCLOB — NOT NULL
  • M_ID — NVARCHAR2(20) — NOT NULL
  • R_DATE — DATE — NOT NULL
  • R_SCORE — NUMBER — NOT NULL

RIMG_TB

  • RIMG_NO — NUMBER — Primary key — NOT NULL
  • R_NO — NUMBER — NOT NULL
  • RIMG_ORI — NVARCHAR2(500) — NOT NULL
  • RIMG_SYS — NVARCHAR2(50) — NOT NULL

SIMG_TB

  • SIMG_NO — NUMBER — Primary key — NOT NULL
  • S_CODE — NVARCHAR2(20) — NOT NULL
  • SIMG_ORI — NVARCHAR2(500) — NOT NULL
  • SIMG_SYS — NVARCHAR2(50) — NOT NULL

SPOT_TB

  • S_CODE — NVARCHAR2(20) — Primary key — NOT NULL
  • S_NAME — NVARCHAR2(20) — NOT NULL
  • S_PHONE — NVARCHAR2(11) — NOT NULL
  • S_ADDR — NVARCHAR2(50) — NOT NULL
  • S_CONTENTS — NCLOB

TICKET_TB

  • T_NO — NUMBER — Primary key — NOT NULL
  • P_NO — NUMBER — NOT NULL
  • T_USE — NCHAR(1) — NOT NULL