NETY

Tables (12)

Group

  • id — uuid — Primary key — NOT NULL
  • name — character
  • category_id — uuid — NOT NULL
  • gage — integer
  • full_headcount — integer — NOT NULL
  • description — character
  • created_by_id — uuid — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_at — timestamp — NOT NULL
  • kakaotalk_link — character

GroupCategory

  • id — uuid — Primary key — NOT NULL
  • category_1 — character — NOT NULL
  • category_2 — character — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_at — timestamp — NOT NULL

ImageMedia

  • id — uuid — Primary key — NOT NULL
  • file_format — character
  • width — integer
  • height — integer
  • updated_at — timestamp — NOT NULL
  • created_at — timestamp — NOT NULL
  • media_id — uuid

LinkGroupUser

  • id — uuid — Primary key — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_at — timestamp — NOT NULL
  • group_id — uuid — NOT NULL
  • user_id — uuid — NOT NULL

LinkTagsUsers

  • id — uuid — Primary key — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_at — timestamp — NOT NULL
  • tag_id — uuid — NOT NULL
  • user_id — uuid — NOT NULL
  • verified — boolean
  • image_id — uuid

Media

  • id — uuid — Primary key — NOT NULL
  • title — character
  • description — character
  • path — character
  • updated_at — timestamp — NOT NULL
  • created_at — timestamp — NOT NULL

Role

  • id — uuid — Primary key — NOT NULL
  • name — character — NOT NULL
  • description — character — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_at — timestamp — NOT NULL

School

  • id — uuid — Primary key — NOT NULL
  • name — character — NOT NULL
  • type — public.schooltypeenum — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_at — timestamp — NOT NULL

Tag

  • id — uuid — Primary key — NOT NULL
  • name — character — NOT NULL
  • created_by_id — uuid — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_at — timestamp — NOT NULL
  • count — integer — NOT NULL

User

  • id — uuid — Primary key — NOT NULL
  • age — bigint
  • birthdate — timestamp
  • like — bigint
  • profile_view — bigint
  • follower_count — bigint
  • following_count — bigint
  • first_name — character — NOT NULL
  • last_name — character — NOT NULL
  • email — character
  • chat_status — boolean
  • is_active — boolean — NOT NULL
  • is_superuser — boolean — NOT NULL
  • role_id — uuid
  • sex — character
  • phone — character
  • description — character
  • school_id — uuid
  • major_id — uuid
  • updated_at — timestamp — NOT NULL
  • created_at — timestamp — NOT NULL
  • hashed_password — character — NOT NULL
  • image_id — uuid

UserFollow

  • id — uuid — Primary key — NOT NULL
  • is_mutual — boolean
  • user_id — uuid — NOT NULL
  • target_user_id — uuid — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_at — timestamp — NOT NULL

alembic_version

  • version_num — character — NOT NULL