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