oneProject

Tables (6)

LJP_CATEGORY

  • CAT_SEQ — NUMBER — Primary key — NOT NULL
  • MEM_ID (MEM_ID2) — 20 — Foreign key → LJP_MEMBER.MEM_ID — NOT NULL
  • CAT_NAME — 20 — NOT NULL
  • CAT_ISDEL — NUMBER

LJP_COMMENT

  • COM_SEQ — NUMBER — Primary key — NOT NULL
  • QNA_SEQ(FK) — NUBMER — Primary key — NOT NULL
  • MEM_ID (MEM_ID2) — 20 — Foreign key → LJP_MEMBER.MEM_ID — NOT NULL
  • COM_CONTENT — 1000
  • COM_STEP — NUMBER
  • COM_REGDATE — DATE
  • COM_STAR — NUMBER
  • COM_UPDATEDATE — DATE
  • COM_ISDEL — NUMBER

LJP_MEMBER

  • MEM_ID — 20 — Primary key — NOT NULL
  • MEM_SEQ — NUMBER
  • MEM_PW — 20
  • MEM_EMAIL — 40
  • MEM_NAME — 40
  • MEM_ADDRESS — 100
  • MEM_PHONE — 40
  • MEM_B_NAME — 40
  • MEM_B_STATUES — 20
  • MEM_ISADMIN — NUMBER
  • MEM_ISAPPROVE — NUMBER
  • MEM_ISDEL — NUMBER
  • MEM_REGDATE — DATE
  • MEM_LOGINTIME — DATE
  • MEM_LOGOUTTIME — DATE
  • MEM_IMAGE — 200

LJP_ORDERLIST

  • ORD_NUM — NUMBER — Primary key — NOT NULL
  • PRO_SEQ (PRO_SEQ2) — NUMBER — Foreign key → LJP_PRODUCT.PRO_SEQ — NOT NULL
  • CAT_SEQ (CAT_SEQ2) — NUMBER — Foreign key → LJP_PRODUCT.CAT_SEQ — NOT NULL
  • MEM_ID (MEM_ID2) — 20 — Foreign key → LJP_PRODUCT.MEM_ID — NOT NULL
  • ORD_BILL — NUMBER
  • ORD_DATE — DATE
  • ORD_ID — 100
  • ORD_PROPRICE — NUMBER

LJP_PRODUCT

  • PRO_SEQ — NUMBER — Primary key — NOT NULL
  • CAT_SEQ (CAT_SEQ2) — NUMBER — Foreign key → LJP_CATEGORY.CAT_SEQ — NOT NULL
  • MEM_ID (MEM_ID2) — 20 — Foreign key → LJP_CATEGORY.MEM_ID — NOT NULL
  • PRO_NAME — 40
  • PRO_IMAGE — 100
  • PRO_PRICE — NUMBER
  • PRO_DESC — 200
  • PRO_REGDATE — DATE
  • PRO_ISDEL — NUMBER
  • PRO_SORT — 10

LJP_QNABOARD

  • QNA_SEQ — NUMBER — Primary key — NOT NULL
  • MEM_ID (MEM_ID2) — 20 — Foreign key → LJP_MEMBER.MEM_ID — NOT NULL
  • QNA_TITLE — 100
  • QNA_CONTENT — 4000
  • QNA_REFER — NUMBER
  • QNA_STEP — NUMBER
  • QNA_DEPTH — NUMBER
  • QNA_READCOUNT — NUMBER
  • QNA_ISDEL — NUMBER
  • QNA_REGDATE — DATE
  • QNA_UPDATEDATE — DATE
  • QNA_FILE_NAME — 200
  • QNA_FILE_LOCATION — 250
  • QNA_ANNOUNCE — NUMBER