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