방빠닥

테이블 (20)

Copy Of bookinfo (CopyOfUntitled)

  • bidx (pk) — int — 기본 키 — NOT NULL
  • btitle (') — String
  • bpublishar (Field) — String
  • bperson (Field2) — String
  • bcontent (Field4) — String
  • bimg (Field3) — base64
  • point (Field6) — int
  • sumcnt (Field7) — int
  • nowcnt (Field8) — int
  • rdate (Field5) — String

bookinfo (Untitled)

  • bidx (pk) — int — 기본 키 — NOT NULL
  • uidx (pk2) — int — 외래 키 → user.uidx — NOT NULL
  • btitle (') — String
  • bpublishar (Field) — String
  • bperson (Field2) — String
  • bcontent (Field4) — String
  • bimg (Field3) — base64
  • point (Field6) — int
  • sumcnt (Field7) — int
  • nowcnt (Field8) — 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
  • title (Field) — String
  • content (Field3) — String
  • rdate (Field4) — String
  • 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
  • uidx (pk22) — int — 외래 키 → bookinfo.uidx — 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
  • uidx (pk22) — int — 외래 키 → bookinfo.uidx — NOT NULL
  • sdate (Field4) — String
  • edate (Field7) — String
  • isyn (Field8) — int