대노회 - APP

테이블 (6)

tb_auth (사용자 인증)

    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