SSJA2
Tables (16)
COMMUNITY
- COM_NO — NUMBER(10) — Primary key — NOT NULL
- M_NO — NUMBER(10) — Foreign key → MEMBERS.M_NO — NOT NULL
- COM_WRITER — VARCHAR2(30) — NOT NULL
- COM_TITLE — VARCHAR2(250) — NOT NULL
- COM_CONTENT — VARCHAR2(8000) — NOT NULL
- COM_DATE — DATE — NOT NULL
- COM_EVAL — NUMBER(5) — NOT NULL
- COM_LIKE — NUMBER(5) — NOT NULL
COUPON
- C_NO — NUMBER(10) — Primary key — NOT NULL
- C_STARTDATE — DATE — NOT NULL
- C_DUEDATE — DATE — NOT NULL
- C_NAME — VARCHAR2(90) — NOT NULL
- DC_PER — NUMBER(2) — NOT NULL
EVENT
- EV_NO — NUMBER(10) — Primary key — NOT NULL
- EV_STARTDATE — DATE — NOT NULL
- EV_DUEDATE — DATE — NOT NULL
- EV_BANNER — VARCHAR2(300) — NOT NULL
EVENTPAGES
- EV_NO — NUMBER(10) — Foreign key → EVENT.EV_NO — NOT NULL
- Field — VARCHAR2(30) — NOT NULL
MEMBERS
- M_NO — NUMBER(10) — Primary key — NOT NULL
- M_ID — VARCHAR2(25) — NOT NULL
- M_PW — VARCHAR2(60) — NOT NULL
- M_NAME — VARCHAR2(25) — NOT NULL
- M_ADDRESS1 — VARCHAR2(150) — NOT NULL
- M_ADDRESS2 — VARCHAR2(60) — NOT NULL
- M_ZIPCODE — VARCHAR2(10) — NOT NULL
- M_BIRTH — DATE — NOT NULL
- M_GRADE — VARCHAR2(10) — NOT NULL
- M_EMAIL — VARCHAR2(25) — NOT NULL
- M_PHONE — VARCHAR2(25) — NOT NULL
- POINT — NUMBER(10) — NOT NULL
- M_DATE — DATE — NOT NULL
ORDERS
- O_NO — NUMBER(10) — Primary key — NOT NULL
- PUR_NO — NUMBER(10) — Foreign key → PURCHASE.PUR_NO — NOT NULL
- PRO_NO — NUMBER(10) — Foreign key → PRODUCT.PRO_NO — NOT NULL
- V_NO — NUMBER(10) — Foreign key → PRODUCT.V_NO — NOT NULL
- QUANTITY — NUMBER(10) — NOT NULL
- DISCOUNT — NUMBER(20) — NOT NULL
- O_PRICE — NUMBER(20) — NOT NULL
- O_PAY — NUMBER(20) — NOT NULL
- USECOUPON — NUMBER(20) — NOT NULL
- O_STATE — VARCHAR2(20) — NOT NULL
OWNEDCOUPON
- M_NO — NUMBER(10) — Foreign key → MEMBERS.M_NO — NOT NULL
- C_NO — NUMBER(10) — Foreign key → COUPON.C_NO — NOT NULL
PRODUCT
- PRO_NO — NUMBER(10) — Primary key — NOT NULL
- V_NO — NUMBER(10) — Foreign key → VENDOR.V_NO — NOT NULL
- PRICE — VARCHAR2(25) — NOT NULL
- QUANTITY — VARCHAR2(25) — NOT NULL
- CATEGORY — VARCHAR2(25) — NOT NULL
- BANNERIMG — VARCHAR2(300) — NOT NULL
- WISH — NUMBER(10) — NOT NULL
- SELLCOUNT — NUMBER(10) — NOT NULL
- PRO_HIT — NUMBER(10) — NOT NULL
- BUSINESS_NAME — VARCHAR2(30) — NOT NULL
PURCHASE
- PUR_NO — NUMBER(10) — Primary key — NOT NULL
- M_NO — NUMBER(10) — Foreign key → MEMBERS.M_NO — NOT NULL
- PUR_TOT — NUMBER(20) — NOT NULL
- PUR_DC — NUMBER(20) — NOT NULL
- PUR_PAY — NUMBER(20) — NOT NULL
- PAY_MENT — VARCHAR2(30) — NOT NULL
- PUR_DATE — DATE — NOT NULL
- PUR_DVADDRESS — VARCHAR2(200) — NOT NULL
- PUR_DV — VARCHAR2(30) — NOT NULL
QnA
- Q_NO — NUMBER(10) — Primary key — NOT NULL
- M_NO — NUMBER(10) — Foreign key → MEMBERS.M_NO — NOT NULL
- Q_WRITER — VARCHAR2(30) — NOT NULL
- Q_TITLE — VARCHAR2(250) — NOT NULL
- Q_CONTENT — VARCHAR2(8000) — NOT NULL
- Q_DATE — DATE — NOT NULL
- Q_HIT — NUMBER(5) — NOT NULL
- Q_CATEGORY — VARCHAR2(30) — NOT NULL
- Q_OPEN_STATUS — VARCHAR2(1) — NOT NULL
REPLY_COMMNITY
- R_COM_NO — NUMBER(10) — Primary key — NOT NULL
- COM_NO — NUMBER(10) — Foreign key → COMMUNITY.COM_NO — NOT NULL
- M_NO — NUMBER(10) — Foreign key → COMMUNITY.M_NO — NOT NULL
- R_COM_WRITER — VARCHAR2(30) — NOT NULL
- R_COM_CONTENT — VARCHAR2(250) — NOT NULL
- R_COM_DATE — VARCHAR2(8000) — NOT NULL
- R_COM_HIT — NUMBER(5) — NOT NULL
- R_COM_LIKE — NUMBER(5) — NOT NULL
REPLY_QnA
- R_Q_NO — NUMBER(10) — Primary key — NOT NULL
- Q_NO — NUMBER(10) — Foreign key → QnA.Q_NO — NOT NULL
- M_NO — NUMBER(10) — Foreign key → QnA.M_NO — NOT NULL
- R_Q_TITLE — VARCHAR2(250) — NOT NULL
- R_Q_CONTENT — VARCHAR2(8000) — NOT NULL
- R_Q_WRITER — VARCHAR2(30) — NOT NULL
- R_Q_DATE — DATE — NOT NULL
- R_Q_HIT — NUMBER(5) — NOT NULL
- R_Q_LIKE — NUMBER(5) — NOT NULL
REPLY_REVIEW
- R_REV_NO — NUMBER(10) — Primary key — NOT NULL
- REV_NO — NUMBER(10) — Foreign key → REVIEW.REV_NO — NOT NULL
- M_NO — NUMBER(10) — Foreign key → REVIEW.M_NO — NOT NULL
- R_REV_WRITER — VARCHAR2(30) — NOT NULL
- R_REV_CONTENT — VARCHAR2(8000) — NOT NULL
- R_REV_DATE — DATE — NOT NULL
REVIEW
- REV_NO — NUMBER(10) — Primary key — NOT NULL
- M_NO — NUMBER(10) — Foreign key → MEMBERS.M_NO — NOT NULL
- PRO_NO — NUMBER(10) — Foreign key → PRODUCT.PRO_NO — NOT NULL
- REV_WRITER — VARCHAR2(30) — NOT NULL
- REV_TITLE — VARCHAR2(250) — NOT NULL
- REV_CONTENT — VARCHAR2(8000) — NOT NULL
- REV_DATE — DATE — NOT NULL
- REV_EVAL — NUMBER(5) — NOT NULL
- REV_LIKE — NUMBER(5) — NOT NULL
VENDOR
- V_NO — NUMBER(10) — Primary key — NOT NULL
- M_NO — NUMBER(10) — Foreign key → MEMBERS.M_NO — NOT NULL
- BUSINESS_NAME — VARCHAR2(30) — NOT NULL
- V_ACCOUNT — VARCHAR2(30) — NOT NULL
- BIZ_LICENSE — VARCHAR2(30) — NOT NULL
- V_FAX — VARCHAR2(20) — NOT NULL
WISHLIST
- M_NO — NUMBER(10) — Foreign key → MEMBERS.M_NO — NOT NULL
- PRO_NO — NUMBER(10) — Foreign key → PRODUCT.PRO_NO — NOT NULL
- V_NO — NUMBER(10) — Foreign key → PRODUCT.V_NO — NOT NULL
- Field — DATE — NOT NULL