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