jbeans

Tables (4)

T_MEMBER (Untitled3)

  • MEMBER_ID (Field) — Primary key
  • MEMBERPW (Field2)
  • MEMBER_NAME (Field3)
  • MEMBER_PHONE (Field4)
  • MEMBER_POSTCODE (Field5)
  • MEMBER_ADDR (Field6)
  • MEMBER_ADDR_DETAIL (Field7)
  • MEMBER_ADDR_ETC (Field8)
  • MEMBER_LIKECNT (Field9)

T_MEMBER_SUBSCRIBE (Untitled4)

  • Key — Primary key — NOT NULL
  • MEMBER_ID (Field) — VARCHAR2 — Foreign key → T_MEMBER.MEMBER_ID

T_RECIPE (Untitled)

  • RECIPENUM(SEQ) (Field2) — NUMNER(38) — Primary key
  • RECIPENAME (Field3) — VARCHAR2
  • RECIPETAG (Field4) — VARCHAR2
  • RECIPESOURCE (Field5) — VARCHAR2
  • MEMBERID (Field) — VARCHAR2
  • RECIPECATEGORY (Field6) — VARCHAR2
  • RECIPEPRICE (Field7) — VARCHAR2
  • RECIPETIME (Field8) — VARCHAR2
  • RECIPEINFO (Field9)
  • RECIPELIKECNT (Field10)

T_RECIPE_STEP (Untitled2)

  • RECIPESTEPNUM(SEQ) (Key) — Primary key — NOT NULL
  • RECIPENUM(SEQ) (Field2) — NUMNER(38) — Foreign key → T_RECIPE.RECIPENUM(SEQ)
  • RECIPEIMG (Field)
  • RECIPEDETAIL (Field3)
  • RECIPENAME (Field4) — VARCHAR2
  • RECIPEREGDATE (Field5) — SYSDATE