대노회 - APP
테이블 (6)
tb_file (파일)
- fileId (file_id) — uuid — 기본 키 — NOT NULL
- typeId (type_id) — uuid
- fileName (file_name) — varchar(100) — NOT NULL
- fileUrl (file_url) — varchar(300) — NOT NULL
- type — enum
- sort — int4 — NOT NULL
- createdAt (created_at) — timestamptz — NOT NULL
- updatedAt (updated_at) — timestamptz — NOT NULL
tb_notification (알림)
- notificationId (notification_id) — uuid — 기본 키 — NOT NULL
- userId (user_id) — uuid — 외래 키 → tb_user.userId — NOT NULL
- message — varchar(200) — NOT NULL
- isRead (is_read) — boolean — NOT NULL
- createdAt (created_at) — timestamptz — NOT NULL
tb_organization (조직)
- organizationId (organization_id) — uuid — 기본 키 — NOT NULL
- leaderUserId (leader_user_id) — uuid — 외래 키 → tb_user.userId
- masterOrganizationId (master_organization_id) — uuid
- type — enum — NOT NULL
- name — varchar(100) — NOT NULL
- phoneNumber (phone_number) — varchar(200) — NOT NULL
- faxNumber (fax_number) — varchar(200) — NOT NULL
- email — varchar(200) — NOT NULL
- address — varchar(200) — NOT NULL
- establishedAt (established_at) — timestamptz — NOT NULL
- activities — json
- business — json
- description — text
- totalMembers (total_members) — int4 — NOT NULL
- regularMembers (regular_members) — int4 — NOT NULL
- specialMembers (special_members) — int4 — NOT NULL
- maleMembers (male_members) — int4 — NOT NULL
- femaleMembers (female_members) — int4 — NOT NULL
- membersLastMonth (members_last_month) — int4 — NOT NULL
- newMembers (new_members) — int4 — NOT NULL
- leftMembers (left_members) — int4 — NOT NULL
- membersThisMonth (members_this_month) — int4 — NOT NULL
tb_user (사용자)
- userId (user_id) — uuid — 기본 키 — NOT NULL
- organizationId (organization_id) — uuid — 외래 키 → tb_organization.organizationId — NOT NULL
- email — varchar(200) — NOT NULL
- password — varchar(200) — NOT NULL
- phoneNumber (phone_number) — varchar(200)
- userName (user_name) — varchar(50) — NOT NULL
- hanjaName (hanja_name) — varchar(50)
- birthDate (birth_date) — timestamptz — NOT NULL
- gender — enum — NOT NULL
- religion — enum
- responsibilities — varchar[]
- faxNumber (fax_number) — varchar(200)
- profileEmail (profile_email) — varchar(200)
- contactUsePlaces (contact_use_places) — enum[]
- address — varchar(200)
- careers — json
- education — json
- licenses — varchar[]
- deviceId (device_id) — varchar(200) — NOT NULL
- userLevel (user_level) — enum — NOT NULL
- workLevel (work_level) — varchar(50)
- userStatus (user_status) — enum — NOT NULL
- favoriteUserIds (favorite_user_ids) — uuid[]
- favoriteOrganizationIds (favorite_organization_ids) — uuid[]
- createdAt (created_at) — timestamptz — NOT NULL
- leftAt (left_at) — timestamptz
tb_user_log (사용자 로그)
- userLogId (user_log_id) — uuid — 기본 키 — NOT NULL
- userId (user_id) — uuid — 외래 키 → tb_user.userId — NOT NULL
- organizationId (organization_id) — uuid — 외래 키 → tb_organization.organizationId — NOT NULL
- userStatus (user_status) — enum — NOT NULL
- createdAt (created_at) — timestamptz — NOT NULL