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