kok

Tables (6)

tbl_company_post_alert

  • id — bigint unsigned auto_increment primary key — Primary key — NOT NULL
  • member_id — bigint unsigned not null
  • member_id (id2) — bigint unsigned not null — Foreign key → tbl_member.id — NOT NULL

tbl_file

  • id — bigint unsigned auto_increment primary key — Primary key — NOT NULL
  • file_origint_name — varchar(255) not null
  • file_name — varchar(255) not null
  • file_path — varchar(255) not null
  • file_size — varchar(255) not null
  • file_content_type — varchar(255) not null
  • created_datetime — datetime default current_timestamp
  • updated_datetime — datetime default current_timestamp

tbl_member

  • id — unsigned auto_increment primary key — Primary key — NOT NULL
  • member_name — varchar(255) not null
  • member_phone — varchar(255) not null
  • member_email — varchar(255) not null unique
  • member_password — varchar(255) not null
  • member_job — varchar(255)
  • member_intro — text
  • member_role — enum('member', 'admin') not null default 'member'
  • member_provider — enum('google', 'naver', 'kakao', 'kok') default 'kok'
  • member_last_login_date — datetime
  • member_status — enum('active','inactive') default 'active' not null
  • created_datetime — datetime default current_timestamp
  • updated_datetime — datetime default current_timestamp

tbl_member_background_file

  • id — bigint unsigned auto_increment primary key — Primary key — NOT NULL
  • file_id — bigint unsigned not null — Foreign key → tbl_file.id — NOT NULL
  • member_id — bigint unsigned not null — Foreign key → tbl_member.id — NOT NULL

tbl_member_profile_file

  • id — bigint unsigned auto_increment primary key — Primary key — NOT NULL
  • file_id — bigint unsigned not null — Foreign key → tbl_file.id — NOT NULL
  • member_id — bigint unsigned not null — Foreign key → tbl_member.id — NOT NULL

tbl_member_storage_file

  • id — bigint unsigned auto_increment primary key — Primary key — NOT NULL
  • file_id — bigint unsigned not null — Foreign key → tbl_file.id — NOT NULL
  • member_id — bigint unsigned not null — Foreign key → tbl_member.id — NOT NULL