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)