project

Tables (6)

BOARD (board)

  • ID — VARCHAR2(100) — Foreign key → MAINPROGRAM.ID — NOT NULL

CBRD (cbrd)

  • SERIAL (serial) — NUMBER(5) — Primary key — NOT NULL
  • PSERIAL (serial2) — NUMBER(5) — Foreign key → MBRD.PSERIAL — NOT NULL
  • ID — VARCHAR2(100) — Foreign key → MBRD.ID — NOT NULL
  • MCOMMENT (comment) — VARCHAR2(100)
  • Field

MAINPROGRAM (mainprogram)

  • ID — VARCHAR2(100) — Foreign key → SEMI_LOG.ID — NOT NULL

MBRD (mbrd)

  • PSERIAL (serial) — NUMBER(5) — Primary key — NOT NULL
  • ID — VARCHAR2(100) — Foreign key → BOARD.ID — NOT NULL
  • TITLE (title) — VARCHAR2(100)
  • MCONTENT (content) — VARCHAR2(100)
  • MDATE (date) — DATE
  • PICTURE (picture) — VARCHAR2(100)
  • FAVORITE (favorite) — NUMBER(5)
  • VIEWS (views) — NUMBER(5)
  • SERIAL2 (serial2) — NUMBER(5)
  • CNT_COMMENT (c_comment) — NUMBER(5)

MONUMENTAL (monumental)

  • PLACE (place) — VARCHAR2(100) — Primary key — NOT NULL
  • ID — VARCHAR2(100) — Foreign key → MAINPROGRAM.ID — NOT NULL
  • EXPLAINMP3 (MP3) — VARCHAR2(100)
  • PICTURE1 (picture) — VARCHAR2(100)
  • PICTURE2 (picture2) — VARCHAR2(100)
  • PICTRUE3 (picture3) — VARCHAR2(100)
  • PICTURE4 (picture4) — VARCHAR2(100)

SEMI_LOG (semilog)

  • ID — VARCHAR2(100) — Primary key — NOT NULL
  • PWD — VARCHAR2(100)
  • IMG_SERVER (imgserver) — VARCHAR2(100)
  • IMG_USER (imguser) — VARCHAR2(100)
  • NATIONALITY (nation) — VARCHAR2(100)
  • COMPL (complete) — NUMBER(2)
  • GOLD (gold) — NUMBER(2)
  • SILVER (silver) — NUMBER(2)
  • BRONZE (bronze) — NUMBER(2)
  • PATH (path) — VARCHAR2(100)