test
Tables (19)
AUTHLOG
- AL_DATE — DATE — Primary key — NOT NULL
- AL_ACTION — NUMBER(1) — Primary key — NOT NULL
- AL_SUCODE — NVARCHAR2(50) — Foreign key → SOCIALUSER.SU_CODE — NOT NULL
- AL_SUCACODE — NCHAR(2) — Foreign key → SOCIALUSER.SU_CACODE — NOT NULL
AVERAGE
- AV_CODE — NCHAR(2) — Primary key — NOT NULL
- AV_CACODE — NCHAR(2) — Foreign key → CATEGORY.CA_CODE — NOT NULL
- AV_NAME — NVARCHAR2(4) — NOT NULL
- AV_VALUE — NVARCHAR2(100) — NOT NULL
BABY
- BB_CODE — NCHAR(2) — Primary key — NOT NULL
- BB_SUCODE — NVARCHAR2(50) — Foreign key → SOCIALUSER.SU_CODE — NOT NULL
- BB_SUCACODE — NCHAR(2) — Foreign key → SOCIALUSER.SU_CACODE — NOT NULL
- BB_NAME — NVARCHAR2(20) — NOT NULL
- BB_BIRTHDAY — DATE — NOT NULL
CATEGORY
- CA_CODE — NCHAR(2) — Primary key — NOT NULL
- CA_NAME — NVARCHAR2(20) — NOT NULL
COMPANY
- CO_CODE — NCHAR(10) — Primary key — NOT NULL
- CO_PASSWORD — NVARCHAR2(500) — NOT NULL
- CO_MANAGERCODE — NVARCHAR2(500) — NOT NULL
- CO_NAME — NVARCHAR2(500) — NOT NULL
- CO_PHONE — NVARCHAR2(500) — NOT NULL
- CO_EMAIL — NVARCHAR2(500) — NOT NULL
- CO_ADDRESS — NVARCHAR2(100) — NOT NULL
COMPANYLOG
- CL_DATE — DATE — Primary key — NOT NULL
- CL_ACTION — NUMBER(1) — Primary key — NOT NULL
- CL_COCODE — NCHAR(10) — Foreign key → COMPANY.CO_CODE — NOT NULL
DAILYDIARY
- DD_CODE — NVARCHAR2(100) — Primary key — NOT NULL
- DD_STASUS — NCHAR(1) — NOT NULL
- DD_CONTENT — NVARCHAR2(1000) — NOT NULL
- DD_VIEW — NUMBER(10) — NOT NULL
DAILYDIARYCOMMENT
- DC_CODE — NVARCHAR2(100) — Primary key — NOT NULL
- DC_DDCODE — NVARCHAR2(100) — Foreign key → DAILYDIARY.DD_CODE — NOT NULL
- DC_CONTENT — NVARCHAR2(1000) — NOT NULL
DAILYDIARYPHOTO
- DP_CODE — NVARCHAR2(100) — Foreign key → DAILYDIARY.DD_CODE — NOT NULL
- DP_COUNT — NUMBER(2) — NOT NULL
- DP_LINK — BLOB — NOT NULL
FREEBOARD
- FB_CODE — NVARCHAR2(100) — Primary key — NOT NULL
- FB_TITLE — NVARCHAR2(100) — NOT NULL
- FB_CONTENT — NVARCHAR2(5000) — NOT NULL
- FB_VIEW — NUMBER(10) — NOT NULL
FREEBOARDCOMMENT
- FC_CODE — NVARCHAR2(100) — Primary key — NOT NULL
- FC_FBCODE — NVARCHAR2(100) — Foreign key → FREEBOARD.FB_CODE — NOT NULL
- FC_CONTENT — NVARCHAR2(1000) — NOT NULL
FREEBOARDPHOTO
- FP_FBCODE — NVARCHAR2(100) — Foreign key → FREEBOARD.FB_CODE — NOT NULL
- FP_COUNT — NUMBER(2) — NOT NULL
- FP_LINK — BLOB — NOT NULL
HASHTAG
- HT_CODE — NCHAR(5) — Primary key — NOT NULL
- HT_DDCODE — NVARCHAR2(100) — Foreign key → DAILYDIARY.DD_CODE — NOT NULL
- HT_NAME — NVARCHAR2(20) — NOT NULL
- HT_COUNT — NUMBER(10) — NOT NULL
HEALTHDIARY
- HD_CODE — NVARCHAR2(100) — Primary key — NOT NULL
- HD_DATE — DATE — Primary key — NOT NULL
- HD_CACODE — NCHAR(2) — Foreign key → CATEGORY.CA_CODE — NOT NULL
- HD_VALUE — NVARCHAR2(100) — NOT NULL
INFOBOARD
- IB_CODE — NVARCHAR2(100) — Primary key — NOT NULL
- IB_TITLE — NVARCHAR2(100) — NOT NULL
- IB_CONTENT — NVARCHAR2(5000) — NOT NULL
- IB_VIEW — NUMBER(10) — NOT NULL
MAPCOMMENT
- MC_CODE — NVARCHAR2(100) — Primary key — NOT NULL
- CO_CODE — NCHAR(10) — Foreign key → COMPANY.CO_CODE — NOT NULL
- MC_CONTENT — NVARCHAR2(100) — NOT NULL
RESERVATION
- RE_CODE — NVARCHAR2(70) — Primary key — NOT NULL
- RE_CACODE — NCHAR(2) — Foreign key → CATEGORY.CA_CODE — NOT NULL
- RE_COMMENT — NVARCHAR2(1000) — VARCHAR2(1000) NUL
SCHEDULE
- SC_CODE — NVARCHAR2(100) — Primary key — NOT NULL
- SC_CONTENT — NVARCHAR2(100) — NOT NULL
SOCIALUSER
- SU_CODE — NVARCHAR2(50) — Primary key — NOT NULL
- SU_CACODE — NCHAR(2) — Foreign key → CATEGORY.CA_CODE — NOT NULL
- SU_NAME — NVARCHAR2(500) — NOT NULL
- SU_PHONE — NVARCHAR2(500) — NOT NULL
- SU_EMAIL — NVARCHAR2(500) — NOT NULL
- SU_NICKNAME — NVARCHAR2(20) — NOT NULL