Bobbi Community

Tables (6)

TBL_ADMIN (Untitled8)

  • no (Key) — int8 — Primary key — NOT NULL — auto increment
  • uid (Field) — varchar(20) — NOT NULL
  • pwd (Field2) — varchar(255) — NOT NULL
  • name (Field3) — varchar(20) — NOT NULL
  • mobile (Field4) — varchar(13) — NOT NULL
  • dept (Field5) — varchar(20) — NOT NULL
  • etc (Field6) — text — NOT NULL
  • reg_date (Field7) — date — NOT NULL
  • reg_time (Field8) — date — NOT NULL
  • is_sa (Field9) — bool — NOT NULL — super admin if it true
  • use_state (Field10) — bool — NOT NULL — account not available if it's false
  • del_state (Field11) — boll — NOT NULL — record deleted if it's true

TBL_CONTENTS (Untitled2)

  • no (Key) — int8 — Primary key — NOT NULL — auto increment
  • users_uid (Key2) — varchar(50) — Foreign key → TBL_USERS.uid — NOT NULL — FK to TBL_USERS
  • title (Field) — varchar(50) — NOT NULL
  • img_url (Field3) — varchar(255) — NOT NULL
  • reg_date (Field4) — date — NOT NULL
  • reg_time (Field5) — time — NOT NULL
  • join_cnt (Field7) — int4 — NOT NULL
  • use_state (Field9) — bool — NOT NULL
  • del_state (Field2) — bool — NOT NULL — record deleted if it's true

TBL_CONTENTS_JOIN (Untitled3)

  • no (Key) — int8 — Primary key — NOT NULL — auto increment
  • contents_no (Key2) — int8 — Foreign key → TBL_CONTENTS.no — NOT NULL — FK to TBL_CONTENTS
  • users_uid (Key3) — varchar(50) — Foreign key → TBL_USERS.uid — NOT NULL — FK to TBL_USERS
  • img_url (Field) — varchar(255) — NOT NULL
  • has_gif (Field2) — bool — NOT NULL
  • has_text (Field3) — bool — NOT NULL
  • reg_date (Field4) — date — NOT NULL
  • reg_time (Field5) — time — NOT NULL
  • use_state (Field6) — bool — NOT NULL
  • gif_json (Field7) — jsonb
  • text_json (Field8) — jsonb
  • del_state (Field9) — bool — NOT NULL — record deleted if it's true
  • hot_cnt (Field10) — int4 — NOT NULL
  • reply_cnt (Field11) — int4 — NOT NULL

TBL_HOT (Untitled4)

  • no (Key) — int8 — Primary key — NOT NULL — auto increment
  • contents_join_no (Key2) — int8 — Foreign key → TBL_CONTENTS_JOIN.no — NOT NULL — FK to TBL_CONTENTS_JOIN
  • users_uid (Key3) — varchar(50) — Foreign key → TBL_USERS.uid — NOT NULL — FK to TBL_USERS
  • reg_date (Field) — date — NOT NULL
  • reg_time (Field2) — time — NOT NULL
  • del_state (Field4) — boll — NOT NULL — record deleted if it's true

TBL_REPLY (Untitled5)

  • no (Key) — int8 — Primary key — NOT NULL — auto_increment
  • contents_join_no (Key2) — int8 — Foreign key → TBL_CONTENTS_JOIN.no — NOT NULL — FK to TBL_CONTENTS_JOIN
  • users_uid (Key3) — varchar(50) — Foreign key → TBL_USERS.uid — NOT NULL — FK to TBL_USERS
  • reply (Field) — varchar(255) — NOT NULL
  • reg_date (Field2) — date — NOT NULL
  • reg_time (Field3) — time — NOT NULL
  • del_state (Field4) — bool — NOT NULL — record deleted if it's true
  • use_state (Field5) — bool — NOT NULL

TBL_USERS (Untitled)

  • uid (Key) — varchar(50) — Primary key — NOT NULL
  • user_type (Field) — int2 — NOT NULL — 0:normal, 1:kakao, 2:naver
  • uid_kakao (Field2) — varchar(50) — NOT NULL
  • uid_naver (Field3) — varchar(50) — NOT NULL
  • curr_access_token (Field4) — varchar(255) — NOT NULL
  • curr_refresh_token (Field5) — varchar(255) — NOT NULL
  • pwd (Field6) — varchar(32) — NOT NULL
  • name (Field7) — varchar(20) — NOT NULL
  • nickname (Field8) — varchar(20) — NOT NULL
  • email (Field9) — varchar(50) — NOT NULL
  • gender (Field10) — int2 — NOT NULL — 0:none, 1:male, 2:female
  • age (Field11) — varchar(10) — NOT NULL — 10-19, 20-29, 30-39...
  • birth_date (Field12) — varchar(5) — NOT NULL — month-day
  • birth_year (Field13) — varchar(4) — NOT NULL — year
  • profile_img_url (Field14) — varchar(255) — NOT NULL
  • reg_date (Field15) — date — NOT NULL
  • reg_time (Field16) — time — NOT NULL
  • last_login_date (Field17) — date — NOT NULL
  • last_login_time (Field18) — time — NOT NULL
  • use_state (Field19) — bool — NOT NULL
  • mobile (Field20) — varchar(13) — NOT NULL
  • no (Field21) — int8 — NOT NULL — auto increment by backend
  • del_state (Field22) — bool — NOT NULL — record deleted if it's true