회원
테이블 (19)
bookinfo (Untitled)
- bidx (pk) — int — 기본 키 — NOT NULL
- sidx (pk2) — int — 외래 키 → store.sidx — NOT NULL
- bname (Field) — String
- bwriter (Field2) — String
- bcontent (Field4) — String
- bimg (Field3) — base64
- point (Field6) — int
- rdate (Field5) — String
fn_QNA (1:1-Q&A idx=Q&A idx)
- idx (pk) — int — 기본 키 — NOT NULL
- id (pk2) — String — 외래 키 → fn_member.idx — NOT NULL
- grade (Field2) — int
- hidden (Field8) — int
fn_cart (caidx = cart idx / idx = content idx /)
- caidx (Key) — int — 기본 키 — NOT NULL
- idx (pk) — int — 외래 키 → fn_content.idx — NOT NULL
- id (Field3) — String
- subject (Field8) — String
- img (Field) — String
- rdate (Field5) — Date
fn_comment (cidx = comment idx / idx = content idx /)
- cidx (Key) — int — 기본 키 — NOT NULL
- idx (pk) — int — 외래 키 → fn_content.idx — NOT NULL
- id (Field3) — String
- yid (Field4) — String
- nickname (Field8) — String
- r_comment (Field) — String
- ref (Field6) — int
- lev (Field7) — int
- rdate (Field5) — Date
fn_conlike (idx=content_ idx)
- idx (pk) — int — 외래 키 → fn_content.idx — NOT NULL
- id (Field) — String
- rdate (Field2) — Date
fn_content (content_idx//writer==nick)
- idx (pk) — int — 기본 키 — NOT NULL
- id (pk2) — String — 외래 키 → fn_member.idx — NOT NULL
- name (Field2) — String
- subject (Field3) — String
- content (Field) — String
- mainimgOri (Field7) — String
- subimg1Ori (Field10) — String
- subimg2Ori (Field11) — String
- mainimgfake (Field12) — String
- subimg1fake (Field13) — String
- subimg2fake (Field14) — String
- conlike (Field4) — int
- readnum (Field5) — int
- refe (Field8) — int
- lev (Field9) — int
- rdate (Field6) — date
fn_member (member_idx)
- idx (pk) — int — 기본 키 — NOT NULL
- id (pk2) — String
- pwd (Field2) — String
- name (Field3) — String
- nick (Field4) — String
- birth (Field) — int
- addr (Field5) — String
- phone (Field6) — String
- grade (Field8) — int
- joindate (Field7) — Date
semi_clike (cidx= comment idx)
- cidx (Key) — int — 외래 키 → semi_comment.cidx — NOT NULL
- id (Field) — String
- rdate (Field2) — Date
semi_comment (cidx = comment idx / idx = content idx)
- cidx (Key) — int — 기본 키 — NOT NULL
- idx (pk2) — int — 외래 키 → semi_content.id — NOT NULL
- r_comment (Field) — String
- nickname (Field8) — String
- clike (Field2) — int
- id (Field3) — String
- yid (Field4) — String
- ref (Field6) — int
- lev (Field7) — int
- rdate (Field5) — Date
semi_content (content idx)
- idx (pk) — int — 기본 키 — NOT NULL
- id (fk) — String — 외래 키 → semi_member.idx — NOT NULL
- nickname (Field2) — String
- content (Field3) — String
- mainimg (Field) — String
- subimg1 (Field7) — String
- subimg2 (Field8) — String
- subimg3 (Field9) — String
- relike (Field4) — int
- readnum (Field5) — int
- rdate (Field6) — date
semi_follow (follow idx)
- id (pk) — String — 기본 키 — NOT NULL
- idx (fk) — int — 외래 키 → semi_content.id — NOT NULL
- yid (Field) — String
- rdate (Field2) — Date
semi_member (member idx)
- idx (pk) — int — 기본 키 — NOT NULL
- id (ck) — String
- pwd (Field) — String
- name (Field2) — String
- nickname (fk) — String
- guide (Field6) — String
- homepage (Field5) — String
- img (Field3) — String
- rdate (Field4) — Date
semi_relike (idx=content idx)
- idx (pk2) — int — 외래 키 → semi_content.id — NOT NULL
- id (Field) — String
- rdate (Field2) — Date
semi_scrap (idx = content idx)
- idx (pk) — int — 외래 키 → semi_content.id — NOT NULL
- id (Field) — String
- yid (Field2) — String
store (store_idx)
- sidx (pk) — int — 기본 키 — NOT NULL
- sid (Field11) — String
- spwd (Field12) — String
- sname (Field2) — String
- snum (Field3) — String
- addr (Field7) — String
- phone (Field8) — String
- point (Field9) — int
- simg (Field4) — base64
- sdate (Field6) — String
- edate (Field10) — String
- grade (Field) — int
- isyn (Field5) — int
unsqna (idx)
- idx (pk) — int — 기본 키 — NOT NULL
- uidx (pk2) — int — 외래 키 → user.uidx — NOT NULL
- sidx (pk3) — int — 외래 키 → store.sidx — NOT NULL
- grade (Field2) — int
- hidden (Field8) — int
user (user_idx)
- uidx (pk) — int — 기본 키 — NOT NULL
- id (ck) — String
- pwd (Field) — String
- name (Field2) — String
- addr (fk) — String
- phone (Field6) — String
- birth (Field5) — String
- phone (Field3) — String
- point (Field9) — int
- sdate (Field4) — String
- edate (Field7) — String
- grade (Field10) — int
- isyn (Field8) — int
userbook (userbook_idx)
- ubidx (pk) — int — 기본 키 — NOT NULL
- uidx (pk2) — int — 외래 키 → user.uidx — NOT NULL
- bidx (pk3) — int — 외래 키 → bookinfo.bidx — NOT NULL
- sdate (Field4) — String
- edate (Field7) — String
- isyn (Field8) — int
userbookmark (bookmarkidx)
- ubmidx (pk) — int — 기본 키 — NOT NULL
- uidx (pk2) — int — 외래 키 → user.uidx — NOT NULL
- bidx (pk3) — int — 외래 키 → bookinfo.bidx — NOT NULL
- sdate (Field4) — String
- edate (Field7) — String
- isyn (Field8) — int