SUB_PJT2

Tables (9)

like_list (Untitled4)

  • no (Key) — int — Primary key — NOT NULL
  • pid (Key2) — int — Foreign key → post_list.pid — NOT NULL
  • uid (Key3) — int — Foreign key → user.uid — NOT NULL
  • email (Field2) — varchar
  • cart (Field) — int

notice (Untitled5)

  • nid (Key) — int — Primary key — NOT NULL
  • title (Field) — varchar
  • content (Field2) — varchar
  • visit (Field3) — int
  • create_date (Field4) — datetime

pack (Untitled6)

  • packno (Key) — int — Primary key — NOT NULL
  • email (Field) — varchar
  • price (Field2) — int
  • cnt (Field3) — int

post_list (Untitled3)

  • pid (Key) — int — Primary key — NOT NULL
  • uid (Key2) — int — Foreign key → user.uid — NOT NULL
  • email (Field) — varchar
  • title (Field2) — varchar
  • location (Field3) — varchar
  • imgurl (Field4) — varchar
  • price (Field5) — int
  • sdate (Field6) — date
  • edate (Field7) — date
  • company_info (Field8) — varchar
  • detail (Field9) — varchar
  • flag (Field10) — int
  • activity (Field11) — varchar
  • create_date (Field12) — datetime
  • likecnt (Field13) — int

purchase (Untitled7)

  • purid (Key) — int — Primary key — NOT NULL
  • pid (Field) — int
  • puse (Field2) — int
  • email (Field3) — varchar
  • packno (Field4) — int
  • serialno (Field5) — varchar
  • seller (Field6) — varchar
  • title (Field7) — varchar
  • sdate (Field8) — date
  • edate (Field9) — date
  • location (Field10) — varchar
  • price (Field11) — price
  • img (Field12) — Longtext

reply_list (Untitled2)

  • rid (Key) — int — Primary key — NOT NULL
  • uid (Key2) — int — Foreign key → user.uid — NOT NULL
  • pid (Key3) — int — Foreign key → post_list.pid — NOT NULL
  • create_date (Field) — datetime

review (Untitled9)

  • rvid (Key) — int — Primary key — NOT NULL
  • pid (Field) — int
  • email (Field2)

tag (Untitled8)

  • tid (Key) — int — Primary key — NOT NULL
  • pid (Field) — int
  • tagname (Field2) — varchar

user (Untitled)

  • uid (Key) — int — Primary key — NOT NULL
  • email (Field) — varchar
  • nickname (Field2) — varchar
  • password (Field3) — varchar
  • name (Field4) — varchar
  • imgurl (Field5) — varchar
  • create_date (Field6) — datetime
  • check_type (Field7) — varchar
  • clocation (Field8) — varchar
  • cphone (Field9) — varchar