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