teamproject

Tables (6)

OAuthToken (Untitled4)

  • access_token (Field) — varchar(50) — NOT NULL
  • tocken_type (Field2) — varchar(50) — NOT NULL
  • refresh_token (Field3) — varchar(50) — NOT NULL
  • scope (Field4) — varchar(50) — NOT NULL
  • expires_in (Field5) — int — NOT NULL
  • refresh_token_expires_in (Field6) — int — NOT NULL

Reply (Untitled5)

  • r_seqno (Key) — int — Primary key
  • b_seqno (Key2) — int — Foreign key → community.b_seqno — NOT NULL
  • email (Key22) — varchar(200) — Foreign key → community.email — NOT NULL
  • nickname (Key222) — varchar(50) — Foreign key → community.nickname — NOT NULL
  • b_seqno (Field) — int — NOT NULL
  • nickname (Field2) — varchar(50) — NOT NULL
  • r_content (Field3) — varchar(255) — NOT NULL
  • replydate (Field4) — timestamp — NOT NULL
  • email (Field5) — varchar(50)

community (Untitled2)

  • b_seqno (Key) — int — Primary key — NOT NULL
  • email (Key2) — varchar(200) — Foreign key → member.email — NOT NULL
  • nickname (Key22) — varchar(50) — Foreign key → member.nickname — NOT NULL
  • nickname (Field) — varchar(50)
  • type (Field2) — varchar(50) — NOT NULL
  • category (Field3) — varchar(20) — NOT NULL
  • breed (Field4) — varchar(20)
  • title (Field5) — varchar(50) — NOT NULL
  • content (Field6) — varchar(255) — NOT NULL
  • bi_org_filename (Field7) — varchar(50)
  • bi_stored_filename (Field8) — varchar(50)
  • bi_filesize (Field9) — bigint
  • bv_org_filename (Field10) — varchar(50)
  • bv_stored_filename (Field11) — varchar(50)
  • bv_filesize (Field12) — bigint
  • hitno (Field13) — int
  • regdate (Field14) — timestamp — NOT NULL
  • likecnt (Field15) — int
  • dislikecnt (Field16) — int

likeCheck (Untitled3)

  • b_seqno (Key) — int — Foreign key → community.b_seqno — NOT NULL
  • email (Key2) — varchar(200) — Foreign key → community.email — NOT NULL
  • nickname (Key22) — varchar(50) — Foreign key → community.nickname — NOT NULL
  • mylikecheck (Field) — char
  • mydislikecheck (Field2) — char
  • likedate (Field3) — timestamp
  • dislikedate (Field4) — timestamp
  • b_seqno (Field5) — int — NOT NULL
  • email (Field6) — varchar(200)

member (Untitled)

  • email (Key) — varchar(200) — Primary key — NOT NULL
  • nickname (Key2) — varchar(50) — Primary key — NOT NULL
  • name (Field) — varchar(50)
  • password (Field2) — varchar(100)
  • lastpwdate (Field3) — timestamp
  • pwcheck (Field4) — int
  • birth (Field5) — datetime
  • m_org_filename (Field6) — varchar(255)
  • m_stored_filename (Field7) — varchar(255)
  • m_filesize (Field8) — varchar(255)
  • role (Field9) — varchar(20)
  • authkey (Field10) — varchar(50)
  • regdate (Field11) — timestamp
  • social (Field12) — varchar(11)

shopping (Untitled6)

  • p_seqno (Key) — int — Primary key
  • p_name (Field) — varchar(50) — NOT NULL
  • p_content (Field2) — varchar(250) — NOT NULL
  • p_org_filename (Field3) — varchar(255) — NOT NULL
  • p_stored_filename (Field4) — vrachar(255) — NOT NULL
  • b_filesize (Field5) — varchar(255) — NOT NULL
  • p_link (Field6) — varchar(255) — NOT NULL