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)