sdfs
Tables (8)
COOKTYPE
- TYPECODE — NUMBER(3,0) — Primary key — NOT NULL
- TYPENAME — VARCHAR2(20 BYTE)
MEMBER
- MEMID — VARCHAR2(30 BYTE) — Primary key — NOT NULL
- MEMPWD — VARCHAR2(30 BYTE)
- MEMNAME — VARCHAR2(24 BYTE)
- MEMNICKNAME — VARCHAR2(30 BYTE)
- MEMEMAIL — VARCHAR2(50 BYTE)
- MEMGENDER — VARCHAR2(12 BYTE)
- MEMGRADE — NUMBER(3,0) — Foreign key
MEMBERGRADE
- MEMGRADE — NUMBER(3,0) — Primary key — NOT NULL
- GRADENAME — VARCHAR2(20 BYTE)
- MEMGRADE (MEMGRADE2) — NUMBER(3,0) — Foreign key → REPLY.MEMGRADE
MEMBERINTEREST
- NATCODE — NUMBER(3,0) — Foreign key
- TYPECODE — NUMBER(3,0) — Foreign key
- MEMID — VARCHAR2(30 BYTE) — Foreign key → MEMBER.MEMID — NOT NULL
NATIONALITY
- NATCODE — NUMBER(3,0) — Primary key — NOT NULL
- NATNAME — VARCHAR2(20 BYTE)
RECIPE
- RECIPECODE — NUMBER — Primary key — NOT NULL
- NATCODE — NUMBER(3,0) — Foreign key
- SITCODE — NUMBER(3,0) — Foreign key
- AMOUNT — NUMBER(3,0)
- COOKTIME — NUMBER(3,0)
- DIFFICULT — NUMBER(3,0)
- MATERIAL — VARCHAR2(1000 BYTE)
- COOKSTEP — VARCHAR2(4000 BYTE)
- COOKTIP — VARCHAR2(1000 BYTE)
- TYPECODE — NUMBER(3,0) — Foreign key
- RECIPECODE (RECIPECODE2) — NUMBER(3,0) — Foreign key → REPLY.RECIPECODE
REPLY
- COMMENTINDEX — NUMBER(3,0) — Primary key — NOT NULL
- MEMGRADE — NUMBER(3,0) — Primary key
- RECIPECODE — NUMBER(3,0) — Primary key
- COMMENTS — VARCHAR2(100 BYTE) — NOT NULL
- COMMENTTIME — DATE
SITUATION
- SITCODE — NUMBER(3,0) — Primary key — NOT NULL
- SITNAME — VARCHAR2(20 BYTE)